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]

Browser not supported