Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selecting records | Excel Discussion (Misc queries) | |||
Selecting Random Records From an Excel Sreadsheet | Excel Worksheet Functions | |||
the formula for random selecting | Excel Discussion (Misc queries) | |||
Selecting Random Data | Excel Worksheet Functions | |||
Selecting Random Data | Excel Worksheet Functions |