I have a list of numbers (1 to 9) in G1:G9 that are displayed in a random
manner, with no duplicates.

In G2 I need to put a random number from 1 to 9 Other than the number in G1.
In G3 the number has to be one of the remaining 7 numbers.
in G4 the number has to be one of the remaining 6 numbers.
etc.
I don't want to use a macro to do this, just functions and not UDF, either.

Any suggestions would be appreciated.

drbobsled.