Finding rows with duplicates in two columns

[James McMurray]

Can someone please help me with a formula or vb code to find all of the rows that match another row on two columns? I need to be able to delete all duplicate rows, but they're only duplicates if two columns match. For example

Please Login or Register  to view this content.

Only rows 1 and 5 would match.

[rylo]

Hi

C1: =IF(SUMPRODUCT(--($A$1:$A$5=A1),--($B$1:$B$5=B1))>1,"Duplicate","")

Copy down to C5.

HTH

rylo

[amreen.chugh]

Hi,

I was not able to find any formula that would help delete the duplicates.
However, I have written a VBA macro that would attain the same result.

You can find it in the attached workbook.
Please execute it on a variety of data (only values in Columns A and B will be compared) and let me know if it helps.

Regards

[James McMurray]

Thanks guys! That helped a lot.