When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions.

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.

It will take a combination of five different functions to get the number of unique values in a column. Which functions you use depends on what values are being counted.

Learn how to count the number of unique and distinct values in a column based on data in another column using array in Microsof Excel.

Excel's COUNT function produces a number of cells containing any value, but only COUNTIF and COUNTIFS can use conditions to narrow your results. The COUNTIF function is used for one condition ...