How can I sort a selection of cells into random order?
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 !
---------------------------------------------------------------------------
"IanS" wrote in message
...
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)
|