All seems to work when I use your formulas. There are ten possible
combinations to check for repeats (note that RAND() recalculates with
every change to the sheet)
If your RAND formula (=rand()*(100-1)+1) is in cells A1:E1 and in
A2:A11 you have the following formulas:
=IF(A1=B1,"Repeat","Good")
=IF(A1=C1,"Repeat","Good")
=IF(A1=D1,"Repeat","Good")
=IF(A1=E1,"Repeat","Good")
=IF(B1=C1,"Repeat","Good")
=IF(B1=D1,"Repeat","Good")
=IF(B1=E1,"Repeat","Good")
=IF(C1=D1,"Repeat","Good")
=IF(C1=E1,"Repeat","Good")
=IF(D1=E1,"Repeat","Good")
Each cell in this range will return "Good" (as there are no
duplicates), plus the odds of a repeat are staggering... unless you use
the INT function =INT(rand()*(100-1)+1).
What is failing for you?
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=469176