getting all possible set combinations of a set of numbers

Hi everyone!

I'd like to get all possible combinations of a number set using excel functions. I'm not OK with VBA.
I mean, for example, we have a set of 4 numbers (1,2,3,4) and we need as result all combinations, without repetitions, using two of the original set.

Thanks in advance.
Juares Castro.

See attached (contains macro). Calculates any Permutation/Combination

Thanks John for your response.
Your macro works good.
Actually I'd like to learn how to do this only with excel functions.
Anyway... thanks again.
Juares Castro.

This a solution supplied by Ron Coderre on this forum in 2012. In my ignorance I don't how to refer you back to the original post so I simply copied Ron's solution. The attached has a sample implementation in Sheet2

Set A1:D1 to 0
Then

A2: =IF(SUM(B1:D1)=6,MOD(A1+1,3),A1)
B2: =IF(SUM(C1:D1)=4,MOD(B1+1,3),B1)
C2: =IF(D1=2,MOD(C1+1,3),C1)
D2: =MOD(D1+1,3)


copy those formulas down through Row_81

Next:

F1: =LOOKUP(A1,{0,1,2},{"a","b","c"})


Copy that formula across and down through I81

Thanks John!

FYI: I find "Googling" queries often throws up answers (which is how I discovered this one): by chance it pointed to this forum.