GROUPCOMBIN

Owned by Charles Bishop (Deactivated)
Jan 30, 2018

Syntax

GROUPCOMBIN(<any>)

Description

Generates all the unique combinations of the values of a group. The combinations are represented as a list. The combinations must have at least two elements.

This is a group series function. This function returns a list. If you require a JSON represented as a string wrap this function in TOJSON, (e.g., TOJSON(FUNCTION(...)). The maximum amount of rows this function can return is 65,520.

Example

Given the following data:

Column1

Column2

A

1

A

2

A

3

B

1

B

2

Applying the above function results in the following spreadsheet:

Column1

GROUPCOMBIN returns

A

[1,2]

A

[1,2,3]

A

[2,3]

A

[1,3]

B

[1,2]