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