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:
Post a Comment