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?
|