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.