Zahtevana stran za zdaj ni na voljo v vašem jeziku. Na dnu strani lahko izberete drug jezik ali takoj prevedete katero koli spletno stran v jezik po izbiri z vgrajeno funkcijo prevajanja Google Chroma.

COUNTUNIQUE

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

COUNTUNIQUE for BigQuery

Counts the number of unique values in a data column

Sample Usage

COUNTUNIQUE(table_name!fruits)

Syntax

COUNTUNIQUE(column)

column: The data column to consider for uniqueness.

Tip: Counting unique rows across multiple columns is not supported

Sample Usage

COUNTUNIQUE(A1:C100)

COUNTUNIQUE(1,1,2,3,5,8,13,A2,B6:B9)

Syntax

COUNTUNIQUE(value1, [value2, ...])

value1 - The first value or range to consider for uniqueness.
value2, ... - [ OPTIONAL ] - Additional values or ranges to consider for uniqueness.

Notes

Although COUNTUNIQUE is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function.

See Also

DCOUNTA: Counts values, including text, selected from a database table-like array or range using a SQL-like query.

DCOUNT: Counts numeric values selected from a database table-like array or range using a SQL-like query.

COUNTIF: Returns a conditional count across a range.

Returns the number of values in a dataset.

COUNTBLANK: Returns the number of empty cells in a given range.

Returns the number of numeric values in a dataset.

Examples

Need more help?

Try these next steps:

Post to the help community Get answers from community members

Math

Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search

Clear search

Close search

Main menu