Hi guys

I am trying to generate a combination list (column D) from various factors.

For example:

question.png

Now, I can generate the full set of combinations when all 3 factors are considered (i.e. No. of factors = 3). This is done using the code:

Please Login or Register  to view this content.
But, how can I modify this code to incorporate possibilities of excluding one factor, such that only combinations of 2 factors are also generated? The order of the combination is not a matter (i.e. not a permutation)

Thanks guys

Regards
Ben