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


G

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!
 
Ad

Advertisements

G

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.
 

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

Top