The formulas are as posted above, all I really need to do is flag if
[=rand()*(100-1)+1] in 5 cells has any duplicates.


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=469176