Deleting duplicate numbers (both original and new ones)

[zozoman]

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

[davegugg]

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.