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