How to use the COUNTA Function to Count Unique Values in Excel
COUNTIFS allows you to count values based on one or more criteria. COUNTIFS Function counts the distinct values from the range.
Formula used is: Sum( 1/COUNTIFS(B2:B22,B2:B22))
Note: Don’t Forget to press the “CTRL+SHIFT+ENTER” to put curly brackets to use an Array formula. Because the array formula doesn’t work in older versions of Excel.
How to Count Unique Values in Excel? 5 Easy Ways
Count Unique values in Excel is a feature that can help you to find the values that occur only once in the huge list of Excel. We often need to report the Unique number of customers purchased, the number of products in our stock, List of regions our business covered.
In this article, we explain how to count unique values in an Excel column.
Before moving ahead you should know the difference between unique values and distinct values.
- Unique Values: These are the values that occur only once. Unique Values from the list {1,2,3,1,4,2,7,5,7} are {3,4,5}.
- Distinct Values: These are the Values that are different. Distinct values from the list are {1,2,3,1,4,2,7,5,7} are {1,2,3,4,5,7}.
Contact Us