Filters - I want to delete single addresses and leave all the dupl
 

I have a worksheet with 6000 names and addresses and I want to filter out
only those addresses that appear once. I actually want to see all the
duplicates. I want to see how many times each person shows up more than once.

After that I want to filter again so that the duplicates now only show up
once each. How do I do that?

Filters - I want to delete single addresses and leave all the dupl
 

Try using something like

=COUNTIF(B$2:B2,B2) and copy down as needed.

Does that get you started?
--
HTH,
Barb Reinhardt



"dw" wrote:

I have a worksheet with 6000 names and addresses and I want to filter out
only those addresses that appear once. I actually want to see all the
duplicates. I want to see how many times each person shows up more than once.

After that I want to filter again so that the duplicates now only show up
once each. How do I do that?