What are the range of numbers from which you are choosing?

1 to 10?

20 to 77 ?

--
Regards,
Tom Ogilvy



"Leon" wrote:

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.