
9 April 2016
In this tutorial you will learn how to count unique values in Excel with formulas, and how to get an automatic count of distinct values in a pivot table.
We will also discuss a number of formula examples for counting unique names, texts, numbers, case-sensitive unique values, and more.
Specifically:
- Count unique values in a column.
- Count unique text values.
- Count unique numbers.
- Count case-sensitive unique values.
- Count distinct values ignoring blank cells.
- Formula to count distinct text values.
- Formula to count distinct numbers.
- Counting case-sensitive distinct values.
- How to count unique and distinct rows in Excel.
- Automatic count of distinct values in a pivot table.
Full article: How to count distinct and unique values in Excel