Using RANDARRAY for a Random Data Generator in Excel: Random Names
For several years I've 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.
Download the workbook: https://datascopic.net/Rand-Names
RANDARRAY allows so much more flexibility and 4 formulas get me as many names as I request.
This video shows how RANDARRAY, COUNTA, INDEX, 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/ins...
Website: http://ozdusoleil.com
My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...
My old blog: http://datascopic.net/blog-2-2