Remove duplicate values
Select the range of cells that has duplicate values you want to remove. Tip: Remove any outlines or subtotals from your data before trying to remove duplicates.Click Data > Remove Duplicates, and then Under Columns, check or ...
