## 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] |