return random number of values

  • Thread starter Thread starter Charlotte Simpson
  • Start date Start date
C

Charlotte Simpson

I have 7000 social security numbers and would like 300
random social security numbers returned.

Thanks,
 
Hi Charlotte
how do you want them returnedß
- on a separate sheet
- manually selected

or do you want to calculate something based on these numbers? Depending
on your desired result you either have to use a macro or you could use
something more simple. e.g.
- add a helper column
- enter the following formula
=RAND()
- copy this formula down for all rows
- sort with this helper columns
- select the first 300 rows and copy them to a separate sheet
 
Suggest the method of;

in the column next to the SS #s, put =RAND() next to the top one and copy it
down to the remaning 699. Now you have 700 SS#s and 700 random numbers next
to them. Then select the SS#s and random #s (all 700), and go to data>sort
and sort by the random numbers. This sorts them randomly. Now you can select
300 from this, for example right off the top. Copy the first 300 SS#s
elsewhere and there you'll have it.
 
Too much Kabel around here...

hglamy

Frank Kabel said:
Hi Charlotte
how do you want them returnedß
- on a separate sheet
- manually selected

or do you want to calculate something based on these numbers? Depending
on your desired result you either have to use a macro or you could use
something more simple. e.g.
- add a helper column
- enter the following formula
=RAND()
- copy this formula down for all rows
- sort with this helper columns
- select the first 300 rows and copy them to a separate sheet
Click to expand...
 
Back
Top