Counting the number of unique values
For example, you want to count the number of unique values of the range:
You can enter the next formula to the range C2:C12:
Summarize amount from a range C2:C12:
This formula in Excel 2016 has no limitation: If the range contains any blank cells, previous versions of Excel return an error.
Permission is granted for article quotations from OfficeToolTips, provided the direct link to the source articlehttp://www.officetooltips.com/excel 2016/tips/counting the number of unique values.html