ExcelBanter - Random Sample

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Random Sample (https://www.excelbanter.com/excel-worksheet-functions/203384-random-sample.html)

Funkyfido

Random Sample

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

Gary''s Student

Random Sample

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?

Mike H

Random Sample

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?

All times are GMT +1. The time now is 09:20 AM.