Tip of the Day | Wednesday 18 November 2026

Discover new tools to get things done.

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

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Example screenshot: 1 (Here's the English version.)
1, Range  ›  20 Clear Duplicate Values in Selection (Keep One Original)
Example screenshot: 2 (Here's the English version.)
2, Range  ›  20 Clear Duplicate Values in Selection (Keep One Original)

Tip:Alt+P for the previous tool.