Dynamic Array Filter, Sort & Unique
There are several formulas for Dynamic Arrays in Excel. The ones we will use in this video are the most frequently use.
What are dynamic arrays? These are formulas that spill the results dynamically in a range of cells.
Dynamic arrays are used better when the source data is formatted as Excel table just like what I did in this video.
Unique is very useful when extracting unique values from a range to be used as a list in data validation.
Filter is used when we would like to extract a portion of our table using filter criteria we specify.
**********************************************
Looking for an Excel or Power BI Online and Live courses please visit
https://pivotviz.com/private-group-tr...
Email: [email protected]