Not in the order

[Guest]

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

 

[Guest]

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.

 

[Guest]

Thanks Tim! It works!!! Excellent. I also thanks for your quick reponse.