Excel Dynamic Array Video#4: Pivot table with total row, FILTER, UNIQUE, SORT, SORT & SUMIFS
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
• Dynamic Array Functions
To download the excel file:
https://drive.google.com/file/d/1fjJW...
To subscribe to the channel:
/ @aaaexcel
To follow on Facebook:
/ excelispower
To follow on LinkedIn:
/ amratef