ExFF14 - Randarray dynamic formula
In September 2018, Microsoft introduced dynamic array formulas. Dynamic array formulas can automatically populate or "spill" into neighboring blank cells, and eliminate the need for legacy Ctrl+Shift+Enter (CSE) array formulas.
These formulas include Sort, SortBy, Filter, Unique, Sequence and RandArray.
In this video, we have discussed the basic concept of the RandArray formula along with a few examples!
Get the file from here:
https://tinyurl.com/y6ltrwq3
Enjoy!