UNIQUE

Removes duplicate rows or columns from a range.

Syntax

UNIQUE(range; orientation)

• range - the range from which the duplicates are removed - Value type: range

• orientation - the orientation in which the duplicates are removed - Value type: constant (optional, vertical as default). Possible values are:

  • horizontal - duplicate columns are removed

  • vertical - duplicate rows are removed

Examples