selecting random records
 

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

selecting random records
 

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" wrote in message
...
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

selecting random records
 

Thanks very much, Bernie

That's brilliant!


Terry
On Thu, 1 Apr 2004 20:15:42 -0500, "Bernie Deitrick" <deitbe @
consumer dot org wrote:

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" wrote in message
.. .
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


==
Terry Freedman
www.ictineducation.org