How to Filter Excel for Duplicate Names

1. Open your Excel spreadsheet.
2. Select one or more columns in which you suspect there are duplicate values.
3. Click on the 'Data' tab at the top of the screen, then the 'Remove Duplicates' icon.
4. Check the boxes with suspected duplicates in the dialog box that opens.
5. Click 'OK.' Another box will appear, telling you how many duplicates have been removed and how many unique values remain.