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

http://www.lynda.com/home/DisplayCourse.aspx?lpk2=56970&utm_source=youtub...

Excel 2007: Introduction to Formulas and Functions shows how to build impressive spreadsheets with the application's built-in capabilities. Excel expert and Microsoft Most Valuable Professional Curt Frye shares his vast knowledge of Excel, demonstrating how to build various arithmetic and statistical analysis formulas. Curt explains how to summarize values in sets of cells, create conditional formulas using IF and other related functions, and use validation rules to make data entry more accurate. He even teaches how to search for data within a list or table using the VLOOKUP and HLOOKUP functions.

Category:

Howto & Style

Tags:

• lynda.com
• training
• tutorials
• Excel 2007

[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