Sellect random 100?

  • Thread starter Thread starter Robert Gillard
  • Start date Start date
R

Robert Gillard

I have a worksheet with approx 800 rows.

Can I select a random 100 records, if so how ?

Bob
 
In an adjacent row put =RAND()

copy down, sort by the help column and select the first 100 rows
 
Clumsy solution...

Insert a column with the formula =RAND() for each row

This generates a random number between 0 and 1 for every
row it is copied to. It will update whenever the
worksheet is re-calculated, so if you sort by this new
column, you can pick off the top 100, or create a new
worksheet and reference the first 100 rows.
 
Without sorting, you can do this. Enter =RAND()<1/8 in cell H2, for example.
Select a cell in your range of records, use Data/Filter/Advanced Filter,
select H1:H2 as your criteria, and you'll get APPROCIMATELY 1/8th of your
records (100/800).

Bob Umlas
Excel MVP
 
For more options other than the ones already suggested, check the
Excel/Tutorials/Random Selection page of my web site.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top