How can I sort a selection of cells into random order?

I

IanS

I wish to sort a list of names into random order, rather than ascending or
descending. Can anyone point me in the right direction? (MS Office 2003)
 
R

Ragdyer

Place/use a "helper" column along side the list and fill that column with
the Rand function.

=Rand()

Then, simply select both columns, and sort on the "helper column.
 
I

IanS

Ragdyer said:
Place/use a "helper" column along side the list and fill that column with
the Rand function.

=Rand()

Then, simply select both columns, and sort on the "helper column.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------



Many thanks for your prompt and helpful answer. Simple!
Click to expand...

IanS
 
Top