Create Random Data, Variable Height INDEX & RANDARRAY Dynamic Array Function: Excel Magic Trick 1545

Download Excel Start Files: http://bit.ly/2IktpTj
Entire page with all Excel Files for All Videos: http://bit.ly/1kSFWvs

In this video learn how to create a random table of text and number data that has a variable for number of rows using the INDEX Lookup Function and the Office 365 Dynamic Array Function RANDARRAY.

View on YouTube