Random Numbers

  • Thread starter Thread starter chumpboy
  • Start date Start date
C

chumpboy

Hello -

I would like to have multiple cells return random numbers from a list.
Easy enough with the Randbetween function. However, I would like to
limit the range when a number is chosen.

For example:

My list of possible numbers is 1-10.

In one cell I want to return, randomly, one of those 10 numbers.
Assume 6 is returned.
I would then like 6 to not be able to come up again.
Then in the next cell, I want another random number from the new list
that does not include 6.

If this isn't possible via the random function or similar, can you sort
data in a random order? Then I would just choose the top 2 numbers
returned after the random sort.

Thank you all
 
One way.

Enter your 1 to 10 in column A. In column B enter and pull down =RAND().
Now sort the two column by the rand column and pick the top two in column A.
Next time you need a random selection just sort again and use the top two.

HTH
Regards,
Howard
 
That worked nicely...any other ideas out there?
Click to expand...

Uh, if it worked nicely, why do you need other ideas? Maybe it worked nicely but
not ideally? If so, what'd be ideal?
 
Back
Top