20 December, 2007

Randomly sorting a list in Excel - Cool trick

I needed to randomly sort a list, in Excel, and I had forgotten how to do it, so I performed an ask.com search and came up with this:  http://www.mrexcel.com/tip093.shtml

Basically, simply add the '=RAND()' function, in each cell adjacent to your list cells -- in a new column -- and then sort the range by that new column.  Each time you sort the range a new sort order will result, due to the random numbers.

Very, very cool.

No comments: