Discover new tools to get things done.
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.
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Tip:Alt+P for the previous tool.