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.
[TABLE="width: 128"]
<tbody>[TR]
[TD]62017000
[/TD]
[TD]8015064
[/TD]
[/TR]
[TR]
[TD]52017000
[/TD]
[TD]8192746
[/TD]
[/TR]
[TR]
[TD]62017000
[/TD]
[TD]8192746
[/TD]
[/TR]
[TR]
[TD]52017000
[/TD]
[TD]8192747
[/TD]
[/TR]
[TR]
[TD]62017000
[/TD]
[TD]8192747
[/TD]
[/TR]
[TR]
[TD]32017000
[/TD]
[TD]8214224
[/TD]
[/TR]
[TR]
[TD]32017000
[/TD]
[TD]8214224
[/TD]
[/TR]
[TR]
[TD]62017000
[/TD]
[TD]8214225
[/TD]
[/TR]
[TR]
[TD]32017000
[/TD]
[TD]8214226
[/TD]
[/TR]
</tbody>[/TABLE]

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.