How to use the UNIQUE Function to Count Unique Values in Excel
If you are using MS Office 365, you can use the below formula to compute the unique count.
” =COUNTA(UNIQUE(B2:B30) “
Syntax:
COUNTA(Value1, Value2,…..)
- Value1 – A cell, excel range, an array of text
- Return count of non-empty cells.
UNIQUE(array, by_col, exactly_once)
- Array – list of data values to return unique
- by_col – Boolean value [ True – return unique columns/ False -return unique rows]
- Exactly_once – Boolean value [return only distinct values ]
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