easy way to remove dup addresses in excel

June 23, 2011 at 11:07:19
Specs: Windows 7
Trying to remove duplicate address. Exp. Spouses who each have a record in a database.

See More: easy way to remove dup addresses in excel

Report •


#1
June 23, 2011 at 13:27:56
Well, thanks for all the detailed information. You sure have made it easy for us to offer suggestions.

We'll get right back to you. ;-)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
June 23, 2011 at 13:46:05
No easy way. Different people can have same address as in a company. A person can have different address. Names can be spelled differently. Different member of family. Change of name or address. No automatic method unless you are willing to risk removing the wrong name.

Report •

#3
June 23, 2011 at 15:37:12
wizard-fred,

re: "No easy way."

You were able to make that assessment based on the limited amount of information given by the OP?

I for one can't tell if any of the conditions you mention even exist in the OP's database.

For all we know it might be as simple as an Advanced Filter or as impossible as you make it sound or somewhere in between.

I'll wait for the OP to provide some detail before I make a decision.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
June 23, 2011 at 22:36:05
Derby - I had helped a friend with a very similar problem with updating/culling a mailing list for possible new and current clients. The cost for a multi-ounce mailing of nearly ten thousand pieces is appreciable. After merging the lists from several sources duplicates were found after sorting by name and by address. Found dup names, misspelled/pseudonyms, members of the same family, moved/new address.
This was found by manual inspection.

Report •

#5
June 24, 2011 at 01:17:35
I have been working with mailing lists for years, so I am familiar with all of the issues that you mentioned, including the wasted cost of mailing multiple pieces to the same address.

My only point was that we have no idea if the OP database contains 10K addresses or 20. We don't know why there are duplicates addresses or anything else about his layout or database structure.

We also don't know his level of Excel expertise. What's easy for some (an Advanced Filter or a sort on multiple columns) might not even be something the OP is aware of.

I'm simply saying that in this case, we can't make the assessment that there is "no easy way" until we know what we are dealing with.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#6
June 24, 2011 at 03:38:59
OK - point made. I was describing some of the possible problems.

Report •

Ask Question