View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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)