Not in the order
 

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

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

Not in the order
 

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

"tim m" wrote:

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