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