Combining Multiple Address Lists and Deleting Duplicates
It's relatively easy to parse the exact duplicates........one solution has
already been posted and there are others..............but one problem exists
with mispellings, other typo's, initials, titles, etc that ordinary
sorting and filtering methods cant find for you. Once you do, whatever
method you choose to get rid of the easy stuff, you will still have to wind
up sorting the melded database and then doing a visual scan to eliminate the
remaining duplicates that only your eye can decern...........
Vaya con Dios,
Chuck, CABGx3
"wgolli" wrote in message
...
I am combining several address lists. All lists are in excel. But some
of the names of one list are also
on the second and third lists. Is there a formula for combining these
lists and excel recognizing the
duplicates/triplicates and then only recording the name once on a Master
Listing. I've been (as in the past)
copying, pasting and then
sorting so that I can view the duplicates and then i manually delete the
duplicates/triplicates. Alot of time is spent doing this. All lists
are set up the same with last name, first name, address, etc each in a
separate column.
|