Did you try "Jay"s solution? If you copy A2:B2 down as far as desired,
you get results (in column B) for each cell in the range [1...9]
excluding the value in the "cell above it".

This post, at least as far as I can tell, doesn't add any information
that would indicate that "Jay"s solution doesn't fit.

Do you *always* want to exclude the same number? Do you want to exclude
more than one number (e.g., 8 and 5)?


In article ,
"Tracker" wrote:

I might of explained it wrong. I want to use random(1,9) but for example i
dont want 5 in the random possibility.Is that possible?