GROUPUNIQUES

Syntax

GROUPUNIQUES(<any>)

Description

Returns unique column values for a group.

This is a group series function.

Example

Given the following raw data:

Create a new worksheet and use the GROUPBY function to group by the Key column from the raw data.

GROUPBY(#RawData!Key)

Next use the GROUPUNIQUES function to create a column which returns the unique values of each group.

GROUPUNIQUES(#RawData!Value)