Excel Function

UNIQUE

Returns unique values from a range.

UNIQUE(array, [by_col], [exactly_once])

Arguments

array

Required

Specify a reference range. You can drag or click start/end cells.

by_col

Optional

Specify TRUE or FALSE.

exactly_once

Optional

Specify TRUE or FALSE.

Practice Preview

show a deduplicated list. Use UNIQUE to Returns unique values from a range. For range arguments, drag from the start cell to the end cell in the same argument field, or click start and end cells in order. use FALSE for by_col, use FALSE for exactly_once. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=UNIQUE(C2:C8, FALSE, FALSE)

Practice This Function

Practice in Sequential ModeBack to Function List