Data Analysis in Excel 5 - Remove Duplicate Entries from Data Sets in Excel

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

This Excel Video Tutorial shows you how to quickly and easily Remove Duplicates from Excel. This tutorial is specific to Excel 2007.

You will learn how to remove duplicates based on one single criteria or column being checked for duplicates as well as by checking multiple columns for duplicates in Excel. This feature in Excel 2007 works great when you need to list only the unique values from a list or database.

For Excel consulting, classes, 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 tips
• excel tricks
• excel guides
• excel tutorials
• excel help
• excel teacher
• spreadsheets
• worksheets
• workbooks
• duplicate values
• delete duplicates in excel
• excel 2007
• remove duplicates
• without a macro
• multiple criteria
• columns
• rows
• based

[sidyahoo97]

Thank you this was really very helpful! I was working on a huge data csv file and facing the same problem. Saved me a lot of time!

[nisar2]

Thanks very helpful god bless u..........

[hakob82]

hi, your tutorial is great, but i am using mac , and under data i can't find remove duplicates buttin, please help!

[mmilos11]

great tutorial ,as the rest !!!!!!!!