Select the range of cells that has duplicate values you want to remove. Subtotals from your data before trying to remove duplicates....