Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to sort al list in random order for sampling?
How can I sort an Excel list into random order to facilitate drawing a sample
of the items on the list? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to sort al list in random order for sampling?
NJTom, you could use a helper column, with data in column A put this in B1
and copy down as far as needed and sort on column B =RAND() -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "NJTom" wrote in message ... How can I sort an Excel list into random order to facilitate drawing a sample of the items on the list? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Order of drop down list | Excel Discussion (Misc queries) | |||
list names in random order in Excel 2002 | Excel Discussion (Misc queries) | |||
Sort with a List | Excel Worksheet Functions | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
Why doesn't the File Open list sort into filename order? | New Users to Excel |