Get all combinations from sets in multiple lists in Google Sheets with COMBINEData GenerationLucas A. Browne Dias
The COMBINE function is a helpful tool that can make it dead simple to generate a list of combinations from other lists.
Whether you're looking to randomly select who's introduced to who, manage a menu of items and assign them to days, or solve a math problem for academic purposes, this function can help get you started.
[number] format; required - how to generate combinations
- 1 - separate rows and columns
- 2 - separate rows
- 3 - single cell
[string] delimiter - also known as the separator for items in a given combination
[arrays] arrays - two or more ranges to combine
Use the CheatHow to Add a Cheat to a Google Sheet
Click the Code Box to Copy