Excel Dynamic Array Functions-Office 365-Video #3: Sales report, Unique & Sort with Sumifs & Index
Hello and welcome to a new video discussing Dynamic Array Formula for Office 365 users. Video #3
If you are not an office 365 user you won’t be able to apply and practice examples in this video
In the previous video we discussed Unique and Sort functions and presented some simple example to illustrate how these 2 functions work.
In this video will continue with unique and sort, but this time will see a comprehensive practical example on how to prepare a dynamic sales report using Unique & Sort together with Sumifs.
We will also look at how lookup function like Index can be extremely useful with spilled arrays, and how we can benefit from date functions like Day and EoMonth
Will also give an example on how to use the #pound with Sum and Sumifs and how these functions will spill automatically under the new calculation engine in Office 365
To watch the full playlist
• Dynamic Array Functions
To download the excel file:
https://drive.google.com/file/d/1Zs4l...
To subscribe to the channel:
/ @aaaexcel
To follow on Facebook:
/ excelispower
To follow on LinkedIn:
/ amratef