Random Sample of Data

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
 
N

Norman Harker

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.
 
Top