I have to randomly select the order 3 values will go in. They are values 27, 28 and 29.

So in cell C11 I have =randbetween(27,29). Easy enough.

In cell E11, I want to randomly select a second number from the remaining pool of unused values.

So let's say "28" comes up in C11. I need the formula in E11 to randomly select either 27 or 29. Then my third cell will obviously be the final value not selected by the first two formulas. I can do that by hand, unless there's a formula for that as well. That would be handy if there was because I have to repeat this for 60 rows.

I was messing around with "=SMALL" but can't quite get it right.

=SMALL(IF(C11={27,28,29},"",{27,28,29}),RANDBETWEEN(27,29))


Any help would be appreciated!

Thanks.