excel2013 How to remove duplicates

excel2013 ways to remove Duplicates:

Remove Duplicates Step 1: First open an Excel file with duplicates, in the example student roster half of the student information is duplicated. We need to get rid of the repetitive students.

Remove Duplicates Step 2: Select the table area you want to heavy, click Data in the menu bar, and then locate the Delete Duplicates button in the Data Tools group. Click the "Remove Duplicates" button

Remove Duplicates Step 3: In the Delete Duplicates dialog box that pops up, select the Student Name column, and the remaining columns are not selected. Click OK

Remove Duplicates Step 4: Click OK to pop up the dialog box, the report has found 8 duplicate values, delete it, retain 8 unique values, so the duplicates are removed. Done.