How to sort al list in random order for sampling?

N

NJTom

How can I sort an Excel list into random order to facilitate drawing a sample
of the items on the list?
 
P

Paul B

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
 
Top