Dynamic Positioning of Totals using Dynamic Arrays in Excel and the new SEQUENCE function

Описание: https://theexcelclub.com/dynamic-posi...
You will find the learn and earn activity in the link above

Learn how to create totals that move (dynamic positioning of totals) using Excel Dynamic arrays and the SEQUENCE function. Dynamic arrays and SEQUENCE are available in Excel 365. The positioning of the total will move in Excel using this method based on the number of rows of data. We need to use a bit of logic but once you know how to do it, you can practice it on the learn and earn activity. I do hope that you will visit the website and while you are here, subscribe to my channel
https://theexcelclub.com/dynamic-posi...

Find out more about our Learn and Earn Activities
https://theexcelclub.com/learn-and-ea...

Watch more Power BI videos
   • Power BI  

Watch more Excel Videos
   • Learn Excel - Playlist