How do you delete duplicate addresses, but keep duplicate names?

[Guest]

I'm trying to modify a mailing list that includes husband, wives, children
with the same mailing address. I'd like to just send one mailing to each
household. I can find where you can delete duplicate rows, but that doesn't
work, because we want to address them to each family member. I'd do this
manually but there are 14,000 names. Thanks for any help!

 

[Guest]

This can be detailic in writing, but sort your list by address, write a
conditional formula in an inserted column that will enter names of those who
have matching addresses. For instance (if c3=c2,b3,c3)...c being the column
listing the addresses, b being the coumn that lists the names...hence, if any
two consecutive addresses match, only the name is returned...if the addresses
don't match, then the unmatched address is returned. The resulting column
will show the address and anyone listed under that address. Not knowing how
your file is set up, you may need to massage the simple formula or add an
additional column to get the primary name from the first address recognized
as unmatched.