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.
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.