I'm trying to build a formula that will consider if the data in column A matches and then if it does I need the formula to consider if the data in column B matches. If column A matches and column B also matches then I need a column C that defines these as a match. If column A matches and column B does not match then I need a column C that defines these as not matching.
I got close with this formula =IF(COUNTIFS($A$2:$A$15000,$A2)*TRUE,"1","0")+AND(B2<>B3), but excel is not considering the rows exclusively and so I ran into an issue with rows 6 & 7 as counting to meet the conditions, but the number in column A does not match between rows 6 and 7.
A B C
1 Number Status Match
2 1018584 1 N
3 1018584 0 N
4 1019528 1 Y
5 1019528 1 Y
6 1031125 1 N
7 1031168 0 N
Your advice is appreciated. Thanks!
Bookmarks