Subsets

[RobertJohn]

Hi all

I want to populate a spreadsheet by using all possible combinations of, for example, three numbers chosen from five numbers. ie if my full set is {1,2,3,4,5} then I want to achieve subsets like {1,2,3}, {1,2,4}, {1,2 5}, {2,3,4} etc. I am happy with the math, and I know there will be 10 in this case, but I need help with the code to generate the subsets.

Can anyone help please?

Thanks in advance.

Robert

[mrice]

There has been another recent post asking a similar question

http://www.excelforum.com/showthread.php?t=638863