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.

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s