How to Remove Duplicate Values From a List in Excel

Excel 2007 and 2010
1. Open your Excel document. Click on the column title above the column from which you want to remove duplicate values. If you do not have column titles, click on any of the data cells in the list. You can highlight multiple columns.
2. Click on 'Data' in the menu bar, then click on the 'Remove Duplicates' button in the Data Tools section. This will open the 'Remove Duplicates' dialogue box. If you highlighted more than one column, you can use the check boxes to specify which columns or lists you want Excel to remove duplicate values from.
3. Click 'OK' to remove all duplicate values from your list. If you have only selected one data cell, Excel will remove duplicate values from the entire list. If you selected more than one column, Excel will only remove values from the columns you specified.
4. Click 'OK' to close the message box that Excel created. If the list had any duplicate values, this message box tells you how many duplicate values it removed and how many unique values remain.
Excel 2003 and Earlier
5. Open your Excel document. Click on the column title above the column where you want to remove duplicate values. Select multiple column titles to remove duplicate values from more than one list.
6. Click on 'Data' in the menu bar, click on 'Filter,' then click on 'Advanced Filter.' This opens the Advanced Filter dialogue box.
7. Click on 'Filter the list, in place' and select the 'Unique records only' check box. Click 'OK.' This will hide the rows containing any duplicate values from previous entries.
8. Highlight the list without any duplicates showing. Click on 'Edit' and choose 'Copy,' or press 'CTRL C,' to copy the list.
9. Click on 'Data' in the menu bar, click on 'Filter' and then click on 'Show All.' This will display the entire list, including the duplicate values. Press the 'Delete' key to delete the list.
10. Click on the first blank cell underneath the column title. Click on 'Edit' and click 'Paste,' or press 'CTRL V,' to paste the list back in without any hidden duplicate values.