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

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.
--
Gary''s Student - gsnu200805


"Funkyfido" wrote:

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

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

"Funkyfido" wrote:

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