Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I sort a selection of cells into random order?
I wish to sort a list of names into random order, rather than ascending or
descending. Can anyone point me in the right direction? (MS Office 2003) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I sort a selection of cells into random order?
Place/use a "helper" column along side the list and fill that column with
the Rand function. =Rand() Then, simply select both columns, and sort on the "helper column. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "IanS" wrote in message ... I wish to sort a list of names into random order, rather than ascending or descending. Can anyone point me in the right direction? (MS Office 2003) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I sort a selection of cells into random order?
"Ragdyer" wrote: Place/use a "helper" column along side the list and fill that column with the Rand function. =Rand() Then, simply select both columns, and sort on the "helper column. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "IanS" wrote in message ... I wish to sort a list of names into random order, rather than ascending or descending. Can anyone point me in the right direction? (MS Office 2003) Many thanks for your prompt and helpful answer. Simple! IanS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to sort al list in random order for sampling? | Excel Discussion (Misc queries) | |||
Random selection of text cells | Excel Discussion (Misc queries) | |||
How do I do a random excel sort or shuffle, in no particular order | Excel Discussion (Misc queries) | |||
random selection from a range of cells | Excel Worksheet Functions | |||
Can you sort text in a random order in Excel | Excel Discussion (Misc queries) |