Can I do a "random order" sort?

  • Thread starter Thread starter In a Pickle
  • Start date Start date
I

In a Pickle

Can I do a "random order" sort? Not alpha or numeric. I need to mix up a set
of rows that are now in alpha order. Thanks for any help.
 
Say your data is in A1 thru A100. In B1 enter:
=RAND() and copy down to B100.
Then sort cols A&B by B. This will "shuffle the cards"
 
In the first free column, enter =RAND() in the first row, then copy down
through all rows of data. Sort by this column to randomize your data.

Hope this helps,

Hutch
 
In an adjacent column enter =RAND() then double-click to copy down.

Select all columns and sort on that column.


Gord Dibben MS Excel MVP

On Tue, 24 Jun 2008 12:16:01 -0700, In a Pickle <In a
 
Back
Top