+ Reply to Thread
Results 1 to 3 of 3

Lengthy situation to find and remove duplicates contacts

Hybrid View

  1. #1
    Registered User
    Join Date
    08-13-2015
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    2

    Lengthy situation to find and remove duplicates contacts

    I am trying to sort a contact list that has over 10000 rows and over 15 columns... However, contact list is not uniform (please refer to the excel file attached). Anyone have any idea on how to efficiently sort these types of contacts? Example.xlsx

    Thank you.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Lengthy situation to find and remove duplicates contacts

    Hi, welcome to the forum

    how would you want it sorted?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-13-2015
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Lengthy situation to find and remove duplicates contacts

    Hi FDibbins. Thank you.

    My objective is to keep the row with the most data and delete the rest. Ideally, I would like merge all of the data together. I have been manually finding duplicates and deleting them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find or Remove Duplicates in Columns
    By dwc in forum Excel General
    Replies: 2
    Last Post: 05-11-2014, 10:38 PM
  2. Find and remove duplicates and/or identifiy both rows
    By WiscoKid in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-18-2013, 08:40 AM
  3. [SOLVED] Find Duplicates and remove the duplicate entry comparing two columns
    By retrospikz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-04-2013, 03:17 AM
  4. 16,000 email list. want a formula to find and remove duplicates.
    By garrettw731 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-10-2012, 04:02 PM
  5. Replies: 5
    Last Post: 02-28-2012, 02:52 PM
  6. Find and remove duplicates?
    By famico78 in forum Excel General
    Replies: 3
    Last Post: 04-30-2009, 07:38 AM

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