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

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.