+ Reply to Thread
Results 1 to 2 of 2

Deleting duplicate numbers (both original and new ones)

  1. #1
    Registered User
    Join Date
    11-15-2011
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    1

    Deleting duplicate numbers (both original and new ones)

    Hello everyone,

    I have a quick quick question (well, hopefully quick haha) about making a macro or using a VBA script.

    I currently set up excel to download certain columns from my MySQL database (lets call it database 'A') and I need to remove certain numbers from them. There are over 14,000 rows and they all contain various numbers in different formats ex. 111-111-1111 or 1111111111.

    Every once in awhile I export a list of numbers from a different database (Database 'B') and I need to remove these number from the first mentioned database's list of numbers. The format database 'B' has for the numbers is 1111111111.

    Does anyone know of an easy way to remove all the numbers that match the numbers I export from database 'B'?

    I've thought of different ways of doing this but I don't know exactly what to do. What I've tried so far is putting everything on the same workpage and using the "locate duplicate" method, but once they are all located I don't know how to delete them all. They just have a different background color.

    If anyone can help, I'd really appreciate it.

    Thanks,

    -Alonzo

  2. #2
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: Deleting duplicate numbers (both original and new ones)

    You can add a help column next to db A's numbers, then use a vlookup (copied down) to identify those numbers in db A that are in your list from db B. Then sort to get all the matches on top or bottom, and delete.

    If you'd care to post a sample workbook, I can give you more detail.
    Is your code running too slowly?
    Does your workbook or database have a bunch of duplicate pieces of data?
    Have a look at this article to learn the best ways to set up your projects.
    It will save both time and effort in the long run!


    Dave

+ 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