Thread: Filters - I want to delete single addresses and leave all the dupl
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DW DW is offline
external usenet poster
  
Posts: 11
Default 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?
Reply With QuoteReply With Quote