Can I do a "random order" sort?

[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.

 

[Gary''s Student]

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"

 

[Bob I]

In a helper column put =RAND() and then sort on that column.

 

[Tom Hutchins]

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

 

[Gord Dibben]

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