Excel Dynamic Array Video#4: Pivot table with total row, FILTER, UNIQUE, SORT, SORT & SUMIFS
Channel: AAA Excel’s Power
Date: 30/07/2020

Hello and welcome to a new video discussing Dynamic Array Formula for Office 365 users. Video #4
If you are not an office 365 user you won’t be able to apply and practice examples in this video
In this Video we will continue with Dynamic Array Functions: Sequence, Unique and Sort, and will add Filter to them.
We are going to use these functions to create and design our own pivot table.
In order to complete the project, we are going to use some other functions such as: Sumifs, Count, CountA, Transpose, and the famous "If" function
We will see how normal functions behaves differently if combined with dynamic arrays and will see how the "#" can work with both normal and dynamic array formulas
Also we will need to create a drop down menu using data validation option
We will work with conditional formatting to make sure that table format is changing properly with the dynamic change of its size

To watch the full playlist 
https://www.youtube.com/playlist?list=PL5NlUYOM2iOgrXzpiyPblTxOpgqGmx3if

To download the excel file:
https://drive.google.com/file/d/1fjJWDSdWhLLoOvbwohnlQlFT12TrF9Y0/view?usp=sharing

To subscribe to the channel:
https://www.youtube.com/channel/UCqwLHNFtrOjrOC3CnvviS1g?sub_confirmation=1

To follow on Facebook:
https://www.facebook.com/excelispower

To follow on LinkedIn:
https://www.linkedin.com/in/amratef