GROUPUNIQUES

Syntax

GROUPUNIQUES(<any>)

Description

Returns unique column values for a group.

This is a group series function.

Example

Given the following raw data:

KeyValue
10
11
21
10
12
21
21
20
21
11
2
1a

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)
Key_GroupsUnique_Value
10
11
12
1a
2
20
21