Thanks, Tom, Gary & Bernie.
I need 8 pairs of rtandom numbers from 0 to 4
I guess Bernie's solution is the lightest to implement once I write all the
possible pairs. Which I guess amount to 20.

Thanks to all


"Bernie Deitrick" wrote:

Leon,

A simple way would be to list your valid pairs in columns A and B, then use the formula

=RAND()

in column C, matching your list in columns A and B. When you want a new set or random pairs, force
a calculation, and then sort based on column C, and take the top 8 pairs from Columns A and B.

HTH,
Bernie
MS Excel MVP


"Leon" wrote in message
...
I need a formula/macro to display a set of 8 pairs of random numbers.
Each number in a pair cannot be equal to the other, numbers in a pair can be
equal to the ones in an other pair.
I tried Randbetween(a,b) but i get a lot of invalid(equal) pairs.

Any help will be gratefully appreciated.