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?

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?