How to count distinct and unique values in Excel

How to count distinct and unique values in Excel

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.