ARRAY.UNIQUE function

This article describes the formula syntax of the ARRAY.UNIQUE function.

Description

Remove consecutive duplicates from array.

Syntax

ARRAY.UNIQUE(array)

array is an array or a handle to an array

This function calls the STL function std::unique on array. Just like std::unique, the array must be sorted to guarantee all duplicate entries are removed.

See Also

ARRAY.SORT