View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
tim m tim m is offline
external usenet poster
 
Posts: 430
Default Not in the order

What i might do is insert a column next to your names column and put the
following formula in that column and copy it down:

=RAND()

This will generate a random number. I would then do your sort of the names
and the random number column but sort via the random number column. This
should end up placing your names in random order.

"Chi" wrote:

Hi,
I have a name list that I can sort it form A - Z or Z - A.

Ex: Ann
Anne
Branny
chi
Day
Font

However, this time I would like to have random list. It will be mix like the
below example.

Ex: Font
Day
Chi
Branny

Thanks
Chi