Random Sample

F

Funkyfido

I have a list of data in excel. Is there anyway that excel can pick a randam
sample of say 20 entries?
 
G

Gary''s Student

Say the data is in column A from A1 thru A1000.
In B1 thru B1000 enter:
=RAND()

Sort cols A&B by B. This will "shuffle" the items in column A.

Just pick the top 20 items in col A.
Re-sort to get another sample.
 
M

Mike H

Hi,

Say your data are in colimn A put this in b1 and double click the fill
handle to make it fill down:-

=Rand()

Now select Columns A & B and sort on column B. The top 20 elements in column
A are randomely selected from the list. Tap F9 and re-sort for another 20.

Mike
 

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

SAMPLE EXCEL DATA 2
Formula numbers and text Trying to pull a random sampling 1
picking random sample in excel column 1
how to randomly select data in excel 4
How do I pull a random sample of people from a list in excel? 6
Dependent drop down dynamic range formula, off sheet. 7
Random Values 7
Random Numbers 2

Top