Select a random sample

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I randomly select a sample of data (rows), from a given set of large
data in the Excel program?
Example: I have 100 rows of information. I need to randomly select 10% or 10
of the rows from the 100 rowed items and place that information on either
another worksheet or another blank area of the existing worksheet.
 
Use a help column, assume the data is in A2:A101, insert and adjacent column
and in B2 put

=RAND()


copy down to B101, select both columns and do data>sort and sort by column
B, select the first 10 rows in A and copy
to a new workbook, save the new workbook, close the workbook with the help
column without saving to get back to it's
original state.


Peo Sjoblom
 
Back
Top