selecting random records

[terry freedman]

Hi

does anyone know how to do this please?

From a spreadsheet consisting of about 800 rows (records) select a
random sample of records(about 50) and also create a data set by
selecting every 10th record.

TIA

Terry
==
Terry Freedman
www.ictineducation.org

 

[Bernie Deitrick]

Terry,

The typical random sample is to insert a column of formulas
=RAND()
and sort on that column, then take the top however-many values you want.

To create a data set, insert a column of formulas
=MOD(ROW(),10)
Copy that column, paste values, then sort on that column and take every
value with the single value, like 1, or 0 or whatever.

HTH,
Bernie
MS Excel MVP

 

[terry freedman]

Thanks very much, Bernie

That's brilliant!


Terry

Terry,

The typical random sample is to insert a column of formulas
=RAND()
and sort on that column, then take the top however-many values you want.

To create a data set, insert a column of formulas
=MOD(ROW(),10)
Copy that column, paste values, then sort on that column and take every
value with the single value, like 1, or 0 or whatever.

HTH,
Bernie
MS Excel MVP

==
Terry Freedman
www.ictineducation.org