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

  • Thread starter Thread starter dw
  • Start date Start date
D

dw

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?
 
Try using something like

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

Does that get you started?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unique Filter Code / Advanced Filter 1
access table results after filtering 1
data filter 4
Problem with filtering 1
filter two worksheets w/ the first as a controller 3
remembering the same filtering criteria 13
VBA code to Fill Down in a filtered list only to visible cells. 1
Is it possible to just act on the filtered data 2

Back
Top