This article describes the formula syntax of the ARRAY.UNIQUE function.
Remove consecutive duplicates from array.
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.