Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |