Select the list; go under Data tab and Data tools section. Choose "Remove duplicates". Now you can choose which columns are searched for duplicates. Press "OK". A message will let you know how many duplicates were found.
officetodo.com/
- How to remove duplicates from the list | Excel 2007 ( Download)
- Remove Duplicates in Excel 2007 ( Download)
- Removing Duplicates rows in Excel 2007 ( Download)
- How to Find & Remove Duplicates in Excel 2007, 2010, 2013 & 2016 | Highlight Duplicates in Excel ( Download)
- How to Find & Remove Duplicate Records in Excel 2007 ( Download)
- Excel Magic Trick 570: Remove Duplicate Records Excel 2007 / 2010 Feature ( Download)
- Highlight & Remove Duplicates in excel ( Download)
- Excel - Removing Duplicates - Episode 415 ( Download)
- How to Remove Duplicates in Excel ( Download)
- Remove Duplicates ( Download)
- How to Remove Duplicates in Microsoft Excel ( Download)
- Removing Duplicates from a List in Microsoft Excel Without a Macro ( Download)
- How to Remove duplicates in excel | Highlight duplicate values in excel | Excel tips & Tricks ( Download)
- How to remove duplicates in excel 2007 ( Download)
- Remove Duplicates in Excel 2007 ( Download)