Combining Multiple Address Lists and Deleting Duplicates

[Guest]

I am combining several address lists. All lists are in excel. But some of the names of one list are als
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 the
sorting so that I can view the duplicates and then i manually delete the duplicates/triplicates. Alot of time is spent doing this. All list
are set up the same with last name, first name, address, etc each in a separate column.

 

[Peo Sjoblom]

If they are identical you can put them all in one list and then use
data>filter>advanced 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

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.

 

[CLR]

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

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.

 

[Guest]

Thank you, CLR and Peo!!

I have been at work with your helps.

Peo

I've tried the hilighting and Tagging that were in the link you sent. It's so great!! But what I'm findin
is that with names like Allen or Smith (very common names in the U.S.) , it won't searc
for a second 'criteria' to help me. For example, I may have Joe, Sarah and Sam Alle
it tells me all are duplicates except for the last one. The range that I put in the formul
did include the second column to successfully extract that for me. Will it search thr
the second column for further duplicates somehow. It just seems it's looking at one column o
info. I really would like for it to read across 3 columns and look at the address too
Example of my sheet: Last Name First Name Addres

Thanks for the web site. It actually tells me how to prevent duplicates on entry too....that wil
be helpful for the future but for now...I need help with what i've got

CLR...I think you are right. But if I can get it to do the tags correctly i probably could do a filte
for all duplicates in that column and then delete. (One of the formulas puts a new column i
the sheet and it will auto fill with duplicate beside the duplicates, kind of neat if you haven't tried it)
And if I can't my eyes wont' hurt a
bad trying to find the duplicates. The way Peo has shown me does alot of work for me. I jus
find the hilights or tags and delete.

I'm on my way!!
wgoll