Home - Information Services - Get Help - How-to-Guides - Excel 2016 - Remove Duplicate Records

Remove Duplicate Records

1. Click any cell that has data in it.
2. On the Data tab, click Remove Duplicates.
   
   
3. Select the column or columns in which you want Excel to look for duplicates.
   
   

4. Click OK.