Remove rows without Duplicates

Using Excel 2007

2 columns: Project Name & Address


Many rows

For these rows, some of the address are duplicates.

I want to remove the rows that don't have duplicate addresses.


Thank you

Try this:-

Please Login or Register  to view this content.

Regards Mick

Hi Mick

The macros work well. How do I learn how to create macros?

For a start, can you explain the code of this macro?

Thank you