Dynamic Array Excel365/2021| Get Value in Multiple Cells | Change the way you write Formula in Excel
Dynamic Arrays are resizable arrays that calculate automatically and return values into multiple cells based on a formula entered in a single cell.
Dynamic Array can be used in following 365 forumulas
1. XLOOKUP
2. UNIQUE
3. FILTER
4. SORT
5. SEQUENCE
6. RANDARRAY
ETC.