Dynamic Positioning of Totals using Dynamic Arrays
In the video above you learned how to create Dynamic Positioning of Totals using Dynamic arrays using Excels SEQUENCE function and some logic. This is an awesome trick that will give any spreadsheet that look professional.
As promised in the video, I have a Learn and Earn Activity for you to complete so you can practice what you have learned.
Download the file. It contains the sample data as shown in the image.
Column A:C contains the data we wish to work with. Cell H2 contains data validation allowing you to select between the customer.
The aim of the task is to pull in the Amount of the invoice into column H, and to include a total value of all invoices.
To aid with this, I have already included a dynamic array formula to pull in the invoice numbers for the selected customer.
Dynamic positioning of totals Learn and Earn Activity
In the comments section below detail the steps and the formula you used to pull in the amount for the invoices and a Dynamic total.
The way shown in the video is not the only way to do this. There are alternatives. If you have an alternative please do share it as you may be providing a valuable resource for someone else.
Do you want to start collecting rewards quickly for learning Excel? Then you should try:
SIGN UP FOR OUR NEWSLETTER TODAY – GET EXCEL TIPS TRICKS AND LEARN AND EARN ACTIVITIES TO YOUR INBOX