logo ASAP Utilities
HomeExtra features for ExcelFormat & LayoutCount Duplicate Values in Selection (Optional Coloring)...

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu
Trustpilot

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

ASAP Utilities  › Format & Layout  ›  21. Count Duplicate Values in Selection (Optional Coloring)...

This tool checks the selected range for duplicate values and informs you of the number found. You can choose to assign a specific fill color to duplicate values to make them easier to identify. By default, you can launch this tool using the Control+Alt+Shift+D shortcut. Note:
  • The tool is case-sensitive. For example, "Excel" and "EXCEL" are considered different values.
  • If your selection includes formulas, the tool compares the calculated values, not the formulas themselves. For instance, if one cell displays the number 12 and another contains the formula =3*4, resulting in 12, they are considered duplicates.
  • Hidden cells within your selection are included in the analysis.
  • In some instances, such as when working with long numeric values like credit card numbers, this tool provides more accurate results than Excel's built-in methods like Conditional Formatting or COUNTIF, which can misidentify such values as duplicates due to rounding.

    Screenshots

    Example screenshot: 1 Count and color duplicated values
    1 Count and color duplicated values
    Example screenshot: 2 No color and just count the duplicated values
    2 No color and just count the duplicated values

    Starting this tool


    Format & Layout  ›  21 Count Duplicate Values in Selection (Optional Coloring)...
    Additional keywords for this tool:
    find duplicates, highlight duplicates, count duplicate values, duplicate data in Excel, duplicate cells, duplicate fields, tag duplicates, deduplicate, dedupe, undouble, identify repeated values, color duplicates, colour duplicates, flag duplicate entries, find duplicate values in selection, Excel duplicate checker, show duplicate cells
    Trustpilot
    Download  



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