Google Sheets COUNTUNIQUE Function | Count Unique Values | Google Sheets Functions
Use the Google Sheets COUNTUNIQUE function to count unique data in a range and or list of values. In contrast, the COUNT function returns the count of numerical data, COUNTIF output is the count of values that meet a single criterion, and COUNTIFS returns the count of values which meet two or more criteria.
----------------------------------------------------
If you are interested in the COUNT, COUNTIF, or COUNTIFS function, here are the links to the video tutorials:
COUNT function tutorial:
• Google Sheets Count | How to Use COUNT in ...
COUNTIF function tutorial:
• COUNTIF Google Sheets | How to Use COUNTIF...
COUNTIFS function tutorial:
• How to use COUNTIFS in Google Sheets | COU...
----------------------------------------------------
The COUNTUNIQUE function requires two attributes, one of which is optional.
Let's look at the format of the COUNTUNIQUE function formula:
=COUNTUNIQUE(value1, [value2])
Start the formula with an equal-to symbol.
COUNTUNIQUE is the name of the function.
value1 is a range or a list of values from which to get a count of unique data.
value2, and other ranges or lists, is optional, and is another range or a list of values.
Note that value1 can be a range and value2 can be a list of values or vice versa.
Here are examples of the Google Sheets COUNTUNIQUE function formula:
Example 1
=COUNTUNIQUE(value1, [value2])
=COUNTUNIQUE(A2:A10)
The above formula will return the count of unique values in the range A2 to A10.
Example 2
=COUNTUNIQUE(value1, [value2])
=COUNTUNIQUE(A2:A10, "fruits")
The output of the above formula will be the count of unique values in the range A2 to A10 plus 1, if fruits is not a value found in the said range.
Example 3
=COUNTUNIQUE(value1, [value2])
=COUNTUNIQUE("vegetables", "fruits", "grains", "confectioneries", "dairy", "vegetables")
The above formula will return 5, because one item is a duplicate item.
Take a look at this video tutorial, which gives the steps to use the Google Sheets COUNTUNIQUE function with an example.
On this page of the site you can watch the video online Google Sheets COUNTUNIQUE Function | Count Unique Values | Google Sheets Functions with a duration of hours minute second in good quality, which was uploaded by the user Software Spring 07 February 2021, share the link with friends and acquaintances, this video has already been watched 15,369 times on youtube and it was liked by 62 viewers. Enjoy your viewing!
