R random Jan 13, 2010 #1 I am interested in pulling a random sample of a excel spreadsheep. The spreadsheet is populated with 132,000 rows.
I am interested in pulling a random sample of a excel spreadsheep. The spreadsheet is populated with 132,000 rows.
B Bob I Jan 13, 2010 #2 In a helper column, put =Rand(), sort the sheet on that column, pick the desired number of rows as the sample.
In a helper column, put =Rand(), sort the sheet on that column, pick the desired number of rows as the sample.
