Random Sample of Data

  • Thread starter Thread starter Helena
  • Start date Start date
H

Helena

I have spreadsheet with about 4000 records, what I want
to do is select just 100 of these records from across the
whole batch.

Does anybody know how i might do this, say by using a
fomula that will put the word select next to 100 records
spread equally across the file.

Hope this makes sense!

Thanks

Daniel
 
Hi Daniel!

Since this involves sorting, make sure you have record numbers so that
you can sort back to the existing order.

Insert a column and in (say) B1 use:

=RAND()
Copy down to the end
Select the column of random numbers
Copy
Edit > Paste Special > Values > OK
Select all of your data
Sort on the random number column
The top 100 are now a random selection.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random Sample of Data 1
Can I link every "fourth" row to a summary worksheet? 2
Select a random sample 2
Excel Date Setting 1
Jump when copying a list of cells 3
Select random records by two conditions 1
does ctrl f select cells randomly? 3
Random selection of records based on specifc value 5

Back
Top