Home Screenshots 10 Languages Why use it?

Tip of the Day | Monday February 16th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Count Distinct Values in Selection

This tool checks the number of distinct (also called unique) values in your selected range and informs you of the number found.
Each value is counted only once, even if it appears multiple times. This means all values that are different from each other are included in the count.

You can choose whether to include hidden cells in your selection, which is useful when working with filtered lists.

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.

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

Info & List › Count Distinct Values in Selection

Starting this tool

Click ASAP Utilities › Info & List › 7. Count Distinct Values in Selection
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 ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Today's Tip

Download

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