+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Removing Duplicates from an Extremely long list

  1. #1
    Registered User
    Join Date
    10-19-2011
    Location
    Brighton, England
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Removing Duplicates from an Extremely long list

    I hope someone can help with this problem i'm having.

    I have been compiling a list of telephone numbers for a friend, which has been compiled from a few different sources, and I am trying to remove all the duplicates.

    There is only one Field which is the telephone number.

    I have looked online and see there are a number of built in functions which can be used to remove duplicates, but they all seem to be based on the list being in one column, and this is where I am having the issue.

    My list contains 220,000 numbers, and the maximum number of rows in Excel is around 65,000. As such my entire list is spread across 4 columns of aprox. 53,000 in each column.

    I have tried creating a macro in vba using the countif function to identify duplicates and the find function to find and delete them, but at the speed this is running, it is likely to take a week of constant running to complete, if not longer.

    Can anyone suggest a quicker way to remove the duplicates, possibly using the functions already built into Excel for finding duplicates?

    Not sure if it is relevant, but the list is not in numerical order and cannot be sorted as the list covers a number of columns, and I only know how to sort the individual columns and not the entire range.

    Any advice would be greatly appreciated

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,454

    Re: Removing Duplicates from an Extremely long list

    Are you using Excel 2007 as your profile indicates? If so there are over a million rows.

    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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