In this Excel Quickie I show you how to generate a random list of words - this trick allows you to input a list of words, numbers, or even formulas, if you wanted, and then have these values randomly output into the worksheet.
You can think of this trick like the RAND() function for a list of words.
I use this trick all the time to create sample sets of data or to fill-in a sparse worksheet for one reason or another.
Enjoy,
Teachexcel.com
0 Comments