Hi,
I need to flag where a Customer Number, (that is supposed to be a matching Duplicate Row) is not matching a Duplicate Customer Name, therefore I need to create a field called "Cust Num Error"
See attachment example.
On a Customer Name level, I want to flag the following:
1 is where the Customer duplicate Names - will have matching duplicate Cust Numbers
0 is where the Customer duplicate Names - will not have matching duplicate Cust Numbers
Anything other scenario, should be flagged Null
I tried using this formula, but it is just giving me all 1's
=(COUNTIFS(A:A,A2,B:B,B2)=COUNTIF(A:A,A2))*1
Thanks in advance
Bookmarks