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
|