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 ...

One major reason Microsoft Excel spreadsheets are so popular ... will skip over any blank row and will not count towards the running total of unique values, as there is no value to be counted.