Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OWC.CHART - Why does my X-Axis come out in the wrong order - somet | Charts and Charting in Excel | |||
Generate Auto Order Number | Excel Discussion (Misc queries) | |||
Series order conflicts with line order | Charts and Charting in Excel | |||
Print order of worksheets | Excel Discussion (Misc queries) | |||
Maintaining a default worksheet order | Excel Discussion (Misc queries) |