GROUPUNIQUES
Syntax
GROUPUNIQUES(<any>)
Description
Returns unique column values for a group.
This is a group series function.
Example
Given the following raw data:
Key | Value |
|---|---|
1 | 0 |
1 | 1 |
2 | 1 |
1 | 0 |
1 | 2 |
2 | 1 |
2 | 1 |
2 | 0 |
2 | 1 |
1 | 1 |
2 |
|
1 | a |
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_Groups | Unique_Value |
|---|---|
1 | 0 |
1 | 1 |
1 | 2 |
1 | a |
2 |
|
2 | 0 |
2 | 1 |