UNIQUE

The UNIQUE function returns each individual value present in an array.

UNIQUE(array, unique-by, occurrence)

array: The array containing the values to return.

unique-by: A boolean value of either TRUE or FALSE.

by row (FALSE or omitted): Returns unique values across rows.

by column (TRUE): Returns unique values across columns.

occurrence: A boolean value of either TRUE or FALSE.

distinct (FALSE or omitted): Returns all unique values.

exactly once (TRUE): Returns values that only appear once.

Notes

Examples

Given the following data in cells A1:C11:

Sales Rep

Genre

Units

Amanda

Fiction

21

Brandon

Fiction

23

Sofia

Nonfiction

49

Julian

Comic

22

Gregory

Nonfiction

32

Julian

Comic

55

Julian

Comic

44

Sofia

Fiction

31

Amanda

Comic

20

Gregory

Nonfiction

55

=UNIQUE(A2:A11) returns an array of each individual name in column A.

=UNIQUE(A2:A11,, TRUE) returns “Brandon” because it is the only name in the array that appears once.

See alsoSORTFILTERTAKE
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Uporabno?
Omejitev znakov: 250
Zgornja omejitev znakov je 250.
Hvala za povratne informacije.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.