Tip of the Day | Thursday March 26th, 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.
Screenshots
Example screenshot: 1
Example screenshot: 2
Starting this tool
- Click ASAP Utilities › Range › 20. Clear Duplicate Values in Selection (Keep One Original)
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.