A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Combining Multiple Address Lists and Deleting Duplicates



 
 
Thread Tools Display Modes
  #1  
Old June 6th, 2004, 12:26 AM
wgolli
external usenet poster
 
Posts: n/a
Default 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  
Old June 6th, 2004, 12:59 AM
Peo Sjoblom
external usenet poster
 
Posts: n/a
Default 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  
Old June 6th, 2004, 02:27 AM
CLR
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:25 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.