Looking for duplicates in 2 different columns

[jayjay226]

Hi there

I'm trying to come up with a formula that looks for duplicates in Column B and return a value of 1 (or True) if their corresponding values in Column A does not match (as per example below, data is not be sorted in any particular order). I can find the duplicates, but struggling with the second part, so hoping someone can help......

A	B	C
931799	2344	0
931799	2344	0
901751	10101	1
931799	10101	1
931799	10102	0
901751	10234	0

<tbody>
</tbody>

Thanks in advance
Jay

 

[Marcelo Branco]

Maybe...

C1 copied down
=IF(AND(COUNTIF(B:B,B1)>1,COUNTIFS(A:A,A1,B:B,B1)=1),1,0)

Hope this helps

M.

 

[jayjay226]

Works perfect! Thanks alot

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.