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

Visit http://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 http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

• microsoft excel 2007
• excel help
• excel guides
• video tutorials
• excel consulting
• excel tips tricks
• learn excel
• excel teacher
• useful hints in excel
• teach me excel
• need to learn to use excel
• consolidate data in excel
• add similar values in excel
• data tools in excel

[MrRspitler]

How can you make the Consolidate auto update. I have 8 sheets that I want to pull from with a total sheet at the end that shows the consolidated information. Do I have to run the consolidate everytime, or can I make it update automatically so the users of the documents don't need to worry about it?

[urakih39]

Omg, thank you so much for posting this video. Took me hours to find a perfect example but it was worth the trouble after watching this.

Your Awesome!!

[chrisnorman83]

Great Video I forgot how to do this!

[GrandDanois]

Thank you very much, i had to consolidate alot of data, and had no idea how to use that function.

Great work! :o)