+ Reply to Thread
Results 1 to 9 of 9

Finding & Deleting Duplicates in a List

  1. #1
    Registered User
    Join Date
    08-24-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2013
    Posts
    55

    Finding & Deleting Duplicates in a List

    I have 3 Excel files, each have thousands of email contacts. I would like to identify and delete any duplicates between the 3 files / lists of emails.

    Any advice for doing this?

    MY guess is the best way would be to move all lists to 1 Excel file and each list is in its own separate tab...call each tab list 1, list 2, list 3...and run some sort of formula that checks / identifies / deletes any duplicates...would a 'vlookup' formula work here? Perhaps a 'match' formula?

    Thanks!

    Dom

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,353

    Re: Finding & Deleting Duplicates in a List

    Perhaps create one long list, then go to Data - Remove Duplicates ?

  3. #3
    Registered User
    Join Date
    08-24-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2013
    Posts
    55

    Re: Finding & Deleting Duplicates in a List

    My apologies...poorly worded question above...

    I want to check for any contacts in List 1 that may also be in List 2 and List 3. If a contact is in List 1 and also in either 2 or 3, I want to delete that contact from List 1, but I do NOT want to add any 'new' contacts from List 2 and List 3 to List 1.

    e.g. Say John Smith is in List 1...and also in List 2...I would then delete John Smith from List 1...Say instead Joe Blow is in List 2 and List 3, but NOT in list 1...I would NOT add Joe Blow to List 1.

    Hope that makes sense. Simple example I hope, again using lists with thousands of contacts.

    Thanks!

    Dom

  4. #4
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Moscow
    MS-Off Ver
    Excel 2010
    Posts
    291

    Re: Finding & Deleting Duplicates in a List

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-24-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2013
    Posts
    55

    Re: Finding & Deleting Duplicates in a List

    Thanks for the quick response!

    My apologies, I dont get ur last post. can u elaborate pls?

  6. #6
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Moscow
    MS-Off Ver
    Excel 2010
    Posts
    291

    Re: Finding & Deleting Duplicates in a List

    There are collections in excel. They always conatin only unique values. If one tries to add not unique item then vba will get error. that's why "On Error resume NExt" needed. Rows after "On error resume next" add items to collection. at the end you get collection of all unique items. The example how to use it you can see in the second part of code ( with listbox). Hope it helps
    Last edited by Alexander_Golinsky; 07-12-2013 at 12:56 PM.

  7. #7
    Registered User
    Join Date
    08-24-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2013
    Posts
    55

    Re: Finding & Deleting Duplicates in a List

    I dont know code...or VBA...I just write formulas in Excel

  8. #8
    Forum Contributor
    Join Date
    04-24-2012
    Location
    Moscow
    MS-Off Ver
    Excel 2010
    Posts
    291

    Re: Finding & Deleting Duplicates in a List

    SORRRYYYYY. my fault!!!!!!!!!!!!!! Try DATA -DATA TOOLS - REMOVE DUPLICATES

  9. #9
    Registered User
    Join Date
    08-24-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2013
    Posts
    55

    Re: Finding & Deleting Duplicates in a List

    No need for yelling dude...Im just looking for some help...Per above, remove duplicates wont help me here...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1