How to sort al list in random order for sampling?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I sort an Excel list into random order to facilitate drawing a sample
of the items on the list?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random Samples 1
Random sorting of list 2
Randomly assigning Data 1
How can I sort a selection of cells into random order? 2
Random Sort 2
mixing up a list 1
How do you randomly assign numbers without getting duplicates? 6
random sampling 5

Back
Top