Nuacht

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.