lynda.com: Excel 2007: Introduction to Formulas and Functions

[TheGift73]

I would also like to have the ability to be able to throw at least 3 data bases against one main database to de-dupe against, and also have the ability to keep a record of the duplicates found, and in which database they were found in. This is quite important as many of our client's wish to know why certain records were removed.

I know that I can't do this with the existing tools in Excell 2007, but if you know of any way, add-ons, VB scrips etc that I accomplish this, I would be very grateful.

[TheGift73]

Fantastic. I'd love to find a video tutorial that can help me create a way to find duplicate addresses in an .xlsx file instead of using the standard 'Remove Duplicates' way.

Lets say that we have 6 addresses that are exactly the same except the addressee's are named as Mr Sam Gailey, Mr Samual Gailey, Mr S Gailey etc A split window could then be presented to the user to show the slight variable in records and give the user the ability to select the ones he wishes to keep and discard the rest