Clear Duplicate Values in Selection (Keep One Original)

ASAP Utilities › Range › 20. 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

1, Range › 20 Clear Duplicate Values in Selection (Keep One Original)

Example screenshot: 2

2, Range › 20 Clear Duplicate Values in Selection (Keep One Original)

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...

Range › 20 Clear Duplicate Values in Selection (Keep One Original)

Additional keywords for 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

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Split Selected Range into Worksheets Based on Column Value or Row Count...

Count Duplicate Values in Selection (Optional Coloring)...

Download

©1999-2025 ∙ 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 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.