COUNTUNIQUE - Google Docs Editors Help (2024)

FAQs

COUNTUNIQUE - Google Docs Editors Help? ›

Understanding the CountUnique Function

The syntax is simple: =COUNTUNIQUE(range), where “range” refers to the cell range containing the values to count. This function efficiently identifies and counts distinct occurrences, providing quick insights into a dataset.

The COUNTIF function counts how many times each individual value appears in the specified range. In this example, COUNTIF(A2:A10,A2:A10) returns the array {1;2;2;1;2;2;2;1;2} . The IF function evaluates each value in the array returned by COUNTIF, keeps all 1's (unique values), and replaces all other values with zeros.

COUNTA counts all values in a dataset, including those which appear more than once and text values (including zero-length strings and whitespace). To count unique values, use COUNTUNIQUE . To count only numeric values use COUNT .

Returns the unique count of a range depending on multiple criteria. Counts the number of unique values in a data column, filtered by a set of criteria applied to additional columns.

The general syntax is as follows: =COUNT(value1, [value2, …]) Value1: This argument should be a cell, range, or array. Value2: If you need to select other ranges, you can add as value2, value3, ….

On the Settings tab, choose "Custom" from the Allow drop down list and enter =COUNTIF($D:$D,D2)=1 into the Formula box.

Counts the number of unique values in a list of specified values and ranges.

The COUNTUNIQUE function counts the number of unique values. So, even when a specific value appears more than once in a data set, the particular value is measured only once. The function does not count the number of entirely blank cells, though it counts the number of cells containing only whitespace(s).

How do I list only unique values in Google Sheets? ›

To get distinct values from another sheet in Google Sheets, use =UNIQUE(SheetName! range), replacing 'SheetName' and 'range' with the relevant sheet name and cell range. If you want to get a list of unique values you need to add the second parameter and set it to TRUE as in =UNIQUE(SheetName!

However, COUNTUNIQUEIFS counts unique values, whereas COUNTIFS counts all values that meet the specified criteria.

Use the COUNTIF formula to find duplicates.

The COUNTIF formula [=COUNTIF (A:A, A1)>1] tells Sheets where to look for duplicates. The information in the parentheses represents the column you want to track and the specific cell you want to start with.

To get distinct values from another sheet in Google Sheets, use =UNIQUE(SheetName! range), replacing 'SheetName' and 'range' with the relevant sheet name and cell range. If you want to get a list of unique values you need to add the second parameter and set it to TRUE as in =UNIQUE(SheetName!

Method 1: Using a Set

A set in Python is an unordered collection of unique elements, meaning that duplicate values are automatically removed when a list is converted to a set. Once we have a set, we can easily determine the count of unique values using the len() function.

When you type =UNIQUE(A2:A15) into cell C2 and hit the Enter key, the UNIQUE function returns all the unique values from range A2:A15. Results start appearing from C2 (the cell where the function is) and flow downwards in the sheet, as you can see in the image below.

The range argument refers to the range of cells that you want to count. For example, if you want to count the non-empty cells in the range A1, you can enter the formula =COUNTA(A1:A10) in a cell. The function will return the number of non-empty cells in the range.