logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

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


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)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

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




Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


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