Consolidate Data in Excel that has Multiple Duplicate Values On the Same Excel Worksheet 

VBA/Macros Course (40% Discount): www.teachexcel...
Excel Forum: www.teachexcel...
Visit www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials.
Learn to consolidate large amounts of data in order to get rid of duplicates using Microsoft Excel 2007. This video tutorial specifically shows you how to take a list of customer purchases, where the same customer has purchased from the store multiple times, and add the purchase amounts of unique customers together. This way, you can quickly see how much a single customer has spent over a given period.
This is the consolidate command in excel 2007 and allows you to quickly display only the unique values in a list while adding together multiple entries of the same item. This is great for users who manage inventory lists or purchasing records.
For Excel consulting or to get the spreadsheet or macro used here visit the website www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.
Have a great day!