A list isn’t, however, a count, so in this article, I’ll show you how to use UNIQUE() to return the count of unique values, indirectly, in Microsoft Excel. First, we’ll review how UNIQUE ...

This will enable the array formula. Now click anywhere outside the cell and you will get the required number of unique values. Count the number of distinct values from a list of a column using the ...

After that, you will know how many unique values are in that column. For some of you, you could follow that until the ROWS function. Let's say your column heading is in C1, and the final value is ...

Duplicates aren't bad, but you may need to know how many times a value is repeated or how many unique values are in a data range. Here's how to tackle these tasks in Excel.