If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combining Multiple Address Lists and Deleting Duplicates
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. |
#2
|
|||
|
|||
Combining Multiple Address Lists and Deleting Duplicates
If they are identical you can put them all in one list and then use
datafilteradvanced filter, copy to another location unique records only. Other wise you need to find some common denominator and use formulas tagging them http://www.cpearson.com/excel/duplicat.htm -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom "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. |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|