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

To download the excel file:

To subscribe to the channel:

To follow on Facebook:

To follow on LinkedIn:

[ozGold]

Excellent video. Thank-you so much. This is very helpful.

[babarqureshi]

Great and thanks for the teaching new ways.

[mariecourlier]

That’s great ! Thanks

One question: let’s say I want to sort the region generating the largest sum of net sales . How would you do that ?

[mahmoudmansour]

Thank you very much, Excellent as usual. But the file doesn't open with me. I practised with file from PT series.