Introducing the most game changing feature of Excel since Pivot Tables - Dynamic Arrays. This powerful new feature allows us to write formulas in a cell that can return an entire range of values (as against a single value).
In this video, you will get a complete overview of the functions and understand their behaviour thru several examples.
For a sample file and more discussion, visit https://chandoo.org/wp/dynamic-array-functions/
The dynamic array functions are,
FILTER
UNIQUE
SORT
SORTBY
SEQUENCE
RANDARRAY
Watch next:
How to use the Spill # operator in Excel - https://youtu.be/kR6czKY4FEw
Detailed video on FILTER Function - https://youtu.be/JuTdj2j-9Kg
How to use the new XLOOKUP Function - https://www.youtube.com/watch?v=DDlZXXEI1bU
#ExcelDynamicArrayFunctions #NewExcelFunctions #DAFunctions #HowtoUseDynamicArrrays
