Excel: Randomly generate names from a list using RANDARRAY and INDEX.
In this video we look at using the RANDARRAY function, combined with the INDEX function, to randomly generate a list of names from an existing list. Useful if you want to create a dummy dataset, a random name selector for a draw or many other purposes.
Check out our other related videos:
How to Generate Random Numbers in MS Excel (RAND, RANDBETWEEN and RANDARRAY): • How to Generate Random Numbers in MS ...
Create random numbers to a specific number of decimal places: • Create random numbers to a specific n...
INDEX function: • INDEX tutorial: Learn all you need to...
Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!
What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)
Want to know more formulas and functions in Excel? Check out our formulas and functions playlist:
• Excel for beginners - FORMULAS and FU...
