Remove / Delete Duplicate Data in Microsoft Excel
Remove duplicate values. Select the range of cells that has duplicate values you want to remove.
Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates.
