Help finding duplicates

Based on your sample, try this.

In C1, copied down...
=COUNTIFS($A$1:$A$61,A1,$B$1:$B$61,B1)

Then you could apply filters and uncheck "1", you would be left with all the duplicates. You can then either copy them elsewhere, delete them or do what you want.

If you want to keep 1 of the duplicates and just show all the 2nd, 3rd duplicates etc, then change the formula to...
=COUNTIFS($A$1:A1,A1,$B$1:B1,B1)

Originally Posted by FDibbins

Based on your sample, try this.

In C1, copied down...
=COUNTIFS($A$1:$A$61,A1,$B$1:$B$61,B1)

Then you could apply filters and uncheck "1", you would be left with all the duplicates. You can then either copy them elsewhere, delete them or do what you want.

If you want to keep 1 of the duplicates and just show all the 2nd, 3rd duplicates etc, then change the formula to...
=COUNTIFS($A$1:A1,A1,$B$1:B1,B1)

It worked like a dream, Thank you very much. You are awesome.