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

[Guest]

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)

 

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

 

[Guest]

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!

IanS