Clear Duplicate Values in Selection (Keep One Original)

This tool removes duplicate values in your selected range while keeping one original. The first occurrence of each value is preserved, and all later instances are cleared.
You can choose whether the comparison should be case-sensitive.

Note:
If your selection includes formulas, the tool compares their calculated values. For example, a cell with the value 12 and a cell with the formula =3*4 are considered duplicates.

Starting this tool

Additional keywords to help you find this tool:
Remove duplicate entries in Excel, Deduplicate selected cells, Duplicate removal tool, Dedupe, Delete duplicate cells, Clear duplicate cells (keep one original), Remove duplicate data in Excel, Double values removal, Clear double entries, Remove duplication in selection, Eliminate double entries, Undouble list in Excel, Clear doubles in selection

Tip:Alt+P for the previous tool.