Using Excel I've just worked out that there will be 550 billion combinations for my 39 numbers:

=COMBIN(39,1)

.

.

.

.

=COMBIN(39,39)

Obviously this isn't practical for my purposes, thank you all for your help anyway.

No, recipie 1 is:

Apple

Recipie 7 is:

Apple

Orange

Banana

I'm looking for combinations, not permutations since the order is unimportant.

In my example there are 3 single value combinations, 3 double value combinations and 1 triple value combination.

I changed the...

When searching for examples many use CROSS JOIN but they are regarding combinations of two different column values, e.g. size and colour. Here is my example data again, hopefully a...

There is only one input table, which is simply a list of numbers. The ID column in the output table represents the combination so if there are 1,000 combinations then...