Thread: Random Samples
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Random Samples

In a helper column, put =Rand(), sort the sheet on that column, pick the
desired number of rows as the sample.

random wrote:
I am interested in pulling a random sample of a excel spreadsheep. The
spreadsheet is populated with 132,000 rows.