Tuesday, December 8, 2009

How do I make a random list in Excel?

How do you make a random list in Microsoft Excel 2007? Well, one way to go about it is as follows. First we have our list.

In the column next to it, put a =rand() into every cell.

This is the random number function, which generates a random number between 0 and 1.

Next, highlight both columns. Sort by the random numbers column and that's it!

Your list has been randomized!