Hi :)

I worked on creating a nice random code generator (three digits,
numerical and alpha) however now I need to find a formula that will
check to see if the code created is unique across several worksheets.

I've tried two methods thus far:

1. First Attempt - Use a IF/AND/Not Equal To formula

=IF(AND(C23<('DNU Priority Codes'!A2:'DNU Priority
Codes'!A1007),C23<('Email Flyer Priority Codes 2006'!A2:'Email Flyer
Priority Codes 2006'!A980),C23<('Tradeshow and Event
Codes'!A2:'Tradeshow and Event Codes'!A1003),C23<('List
Codes'!A2:'List Codes'!A1002),C23<('Priority Code
Archive'!A2:'Priority Code Archive'!A1002)),"Not OK","OK")

2. Second Attempt - Tried a COUNTIF formula just to see if it'd work
with even just one of the sheets:

=IF(COUNTIF('DNU Priority Codes'!$A$2:'DNU Priority
Codes'!A1007,C1)1,"Not Ok","Ok")

Neither of them work. I don't get an error, just the "Ok" even when I
know for a facts that the code is a duplicate. I cannot seem to find
where the formulas are going wrong.

Please Help!

J


--
jloos
------------------------------------------------------------------------
jloos's Profile: http://www.excelforum.com/member.php...o&userid=36980
View this thread: http://www.excelforum.com/showthread...hreadid=567014