Google Sheets COUNTUNIQUE Function | Count Unique Values | Google Sheets Functions
HTML-код
- Опубликовано: 6 фев 2021
- 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 | ...
COUNTIF function tutorial:
• COUNTIF Google Sheets ...
COUNTIFS function tutorial:
• How to use COUNTIFS in...
----------------------------------------------------
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.