Using RANDARRAY for a Random Data Generator in Excel: Random Names

/in /by

For several years I’m maintained my own random data generator in Excel. It makes heavy use of RAND and RANDBETWEEN. However, with the use of Dynamic Arrays and the new RANDARRAY function I’ve been rebuilding the random data generator.

RANDARRAY allows so much more flexibility and 4 formulas get me as many names as I request.

This video shows how RANDARRAY, COUNTA, Tables and the new calculation engine in Excel can easily generate 900 first names, last names and middle initials.

#RANDARRAY
#DynamicArrays
#RandomDataGenerator

For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
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