Find Duplicate values with corresponding values.

[srizki]

Hi all,
I am looking for a formula. I have values in column A and corresponding values in column B, I want to find out if the duplicate exists with the two cells. For example, if I have.

62017000	8015064
52017000	8192746
62017000	8192746
52017000	8192747
62017000	8192747
32017000	8214224
32017000	8214224
62017000	8214225
32017000	8214226

<tbody>
</tbody>

The underlined (italic) values are duplicate.

Thanks

 

[Marcelo Branco]

Try something like this

Formula in C1 copied down
=IF(COUNTIFS(A:A,A1,B:B,B1)>1,"Duplicate","")

Hope this helps

M.

 

[srizki]

Thank you Marcelo,
I was using,
=IF(SUMPRODUCT($A$6:A6=A6)*($B$6:B6=B6)>1,"Duplicate","okay")
That did not work.

Cheers.