About this tutorial:
Video duration: 00:16:38
Welcome to Learn Xtra 😍
What are Dynamic Array Functions in Excel?
DYNAMIC ARRAY FUNCTIONS
The dynamic array allows formulas to return multiple results to a range of cells on the worksheet based on a single formula entered in one cell.
This behavior is called “spilling” and results appear in a “spill range”.
All results are dynamic – if source content changes, the results dynamically update to stay in sync.
The Excel UNIQUE function can extract a list of distinct values, or a list of values that only occur once, i.e. unique values.