Remove Duplicates in Excel
If I need a list of unique items from a long list, I usually use an Advanced Filter, because it leaves the original list alone, and extracts a list of unique records. But, if you want to remove duplicate items quickly and easily, there’s a new tool in Excel 2007.
Excel 2007
In Excel 2007, if there are duplicate items in a list, you can delete them by using the Remove Duplicates tool, which is new in this version.
To remove the duplicates, follow the steps in this short Excel video tutorial.
One or More Columns
In Excel 2007 or later, if there are duplicate items in a list, you can delete them by using the Remove Duplicates tool. The duplicates can be removed based on entries in a single column, or multiple columns
To remove the duplicates, follow the steps in this short Excel video tutorial.
Excel 2003
In Excel 2003, if there are duplicate items in a list, you can delete them by using an Advanced Filter.
To remove the duplicates, follow the steps in this short Excel video tutorial.
______________