Comparing two columns formula help needed

Originally Posted by FDibbins

Apologies, just re-read your quesion and looked at the sample again...
=IF(COUNTIFS($E$2:$E$10,A2,$F$2:$F$10,B2),"not Converted", "Converted")
copied down

You sir are a gentleman and a scholar. Thank you for the assistance

maybe.

Originally Posted by Cubicle Convict

---if any of the number sets in COL A are not in COL E

silent re columns B,F

Originally Posted by FDibbins

If I understand you properly, you want it to say Not Found, instead of Converted?

If so, just swap those words in the formula.

Well no, let me explain; the string of numbers in col A is actually a unique id and the two digit code in col B will always be either T1, T2 or T3. That unique string is then run through a program and then output with that same unique id however sometimes it changes the two digit code after it and sometimes it doesn't and also sometimes the unique id doesn't get output from the program at all.

The Converted is to show those where the unique id has remained the same and the two digit code has changed from T1, T2, or T3 into some other two digit code other than T1, T2, or T3.
The Not Converted is to show those where the unique id has remained the same and the two digit code has NOT changed from T1, T2, or T3 into something else. It is output as still T1, T2, or T3.
The Not Found would be for those instances where the unique id was never output from the program and is not found in col E.

As it is now if the unique id is not found in col E it will just list Converted when really the two digit code hasn't been converted to something other than T1, T2, or T3.

Does that help?

Originally Posted by FDibbins

Try this...
=IF(ISERROR(MATCH(A2,E2:E10,0)),"Not Found",IF(COUNTIFS($E$2:$E$10,A2,$F$2:$F$10,B2),"not Converted","Converted"))

works like a champ, thanks AGAIN !!!