If you do not need to have a non uniform distribution in your selection.
one method is to in the column next to the data enter
=rand()
Select the two columns and sort by the rand column. Your data wiill now be
in a random order. If you just select the data in series you will have a non
replace random selection.
If you nned a new set, just sort by the rand column again.
If you need a replace type selection.
at the top of the column next to the data enter 0 then one cell down enter
=1/data count.
Increment by the 1/data count to the bottom of the data.
then set up a series of random numbers betwween 0 and 1, and use these as
your selection criteria in a Vlookup
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.
