The New & Improved RANDARRAY Dynamic Array Function

/in /by

Lordy! This is a good one! Just within the past week the RANDARRAY function was improved! Dynamic Arrays, the functions and the new calculation engine just keep getting better.

RANDARRAY. WOW! This is better than both the old RAND and RANDBETWEEN functions!

This video shows 2 examples of using RANDARRAY. In the olden days, we would have needed more than just this one function. You will also see RANDARRAY used with INDEX and COUNTA! Everything you possibly could need … it’s all here, brothers and sisters. It’s all here, and it’s FIRE!

#DynamicArrays
#RANDARRAY
#ExcelFunctions
For more Excel and an intro to Get & Transform (Power Query) see my Lynda/LinkedIn courses:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2