Random Numbers

[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

 

[L. Howard Kittle]

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

 

[Harlan Grove]

That worked nicely...any other ideas out there?

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