duplicate cells

[GTR Students]

need to identify duplicate cells when using the =rand function.
ive tried =countif
=match
if statements
and nothing works.

I was just wodering if there was a simple function to use, that can detect
duplicates in a range of cells, and maybe also show you how many, for example
in lottery.

Also following that, is there a function that can stop duplicate numbers
from appearing whilst using the =rand function?

Thanks
GTR

 

[Joel]

The best way is to use two columns when you are looking for random numbers.
If you want 1000 random numbers put 1 to 1000 in columnA. Then put in column
B the formula =RAND(). Now sort the two columns using column B as the Key.
column A will be a sorted list with no duplicates.