Forum Discussion
Finding duplicate value based on multiple criteria from another column
Hello fellow Excel users, I was hoping I would be able to find some support here with a formula I am hoping to find that solves my issue. I want to find duplicates in one column (A) based...
How about this?
=IF(AND(COUNTIFS($A$2:$A$7,A2,$B$2:$B$7,{"CA","US"}),OR(B2="CA",B2="US")),"Y","N")
If you place the formula in D2 and copy it down, it will produce an output like below...