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.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s