Advanced Unique Values Count Calculator

Calculator Form

Paste a list, choose cleanup rules, and count distinct entries accurately.

Values list

Examples: names, scores, IDs, codes, categories, labels, or mixed text values.

Delimiter

Custom delimiter

Sort output by

Chart value limit

Trim leading and trailing spaces

Ignore blank entries

Case sensitive comparison

Normalize numeric strings like 010 and 10.0

Example Data Table

Example below assumes trimming is on, blanks are ignored, case sensitivity is off, and numeric normalization is enabled.

Row	Input	Cleaned	Result
1	Apple	apple	Unique
2	Banana	banana	Unique
3	apple	apple	Duplicate
4	Banana	banana	Duplicate
5	010	10	Unique
6	10.0	10	Duplicate
7	Grape	grape	Unique
8	[blank]	[blank]	Ignored blank

Formula Used

Unique count
U = |{v′₁, v′₂, v′₃, ..., v′_n}|

Duplicate entries
D = N − U

Unique ratio
Unique % = (U ÷ N) × 100

Frequency of a value
f(x) = number of times the cleaned value x appears in the counted list

Here, N is the number of counted entries after selected cleaning rules. The cleaned value v′ means the original entry after trimming, case handling, blank filtering, and optional numeric normalization.

How to Use This Calculator

Paste your values into the list box. You can use commas, line breaks, tabs, semicolons, or pipes.
Select the delimiter or keep auto detection enabled for mixed simple lists.
Choose cleanup options such as trimming spaces, ignoring blanks, case sensitivity, and numeric normalization.
Pick how you want the output sorted and decide how many values should appear in the chart.
Press Count Unique Values to view the summary, chart, frequency table, parsed preview, and exports.

FAQs

1. What does the unique count represent?

It represents how many different cleaned values remain after your selected rules are applied. Cleaning can remove blanks, trim spaces, combine letter case, or normalize numbers before counting distinct items.

2. What is the difference between parsed entries and counted entries?

Parsed entries are all pieces found after splitting the list. Counted entries exclude values removed by your rules, such as blank entries ignored during cleanup.

3. Why do Apple and apple sometimes count as one value?

That happens when case sensitive comparison is off. In that mode, uppercase and lowercase letters are treated as equivalent during matching.

4. Why can 010 and 10.0 become the same value?

If numeric normalization is enabled, numeric strings are converted to a comparable standard form. That lets values like 010, 10, and 10.0 match as the same number.

5. Does the chart show every value?

The chart shows the top values up to your chosen chart limit. This keeps the graph readable when your list contains many distinct items.

6. Can I use this for IDs, tags, categories, or names?

Yes. It works for many list types, including labels, product codes, survey answers, category names, short text entries, and simple numeric strings.

7. What does duplicate entries mean here?

Duplicate entries are repeated occurrences beyond the first appearance of each unique value. They are calculated as counted entries minus unique values.

8. When should I turn off blank ignoring?

Turn it off when blank positions are meaningful in your dataset. Leaving blanks in the count can help you inspect missing values as a separate distinct item.