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

Non-Fiction

49

Julian

Comic

22

Gregory

Non-Fiction

32

Julian

Comic

55

Julian

Comic

44

Sofia

Fiction

31

Amanda

Comic

20

Gregory

Non-Fiction

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.
ସହାୟକ କି?
କ‍୍ୟାରେକ୍ଟର୍ ସୀମା: 250
ସର୍ବାଧିକ କ‍୍ୟାରେକ୍ଟର୍ ସୀମା 250 ଅଟେ।
ଆପଣଙ୍କ ମତାମତ ପାଇଁ ଧନ‍୍ୟବାଦ।
Morty Proxy This is a proxified and sanitized view of the page, visit original site.