Combinations

[FBB]

Any suggestions for a formula that returns all combinations of a given set?

For example A, B, C

would return:

A, B, C
A, C
A, B
A
B
C

 

[kchiba]

Hi FBB,

Return from where, or are you after all the possible permutations from A,B,C? I doubt that you have captured all the possible results from A,B,C, for example

B, C, A
A, C, B
etc.


kanti

 

[NARAYANK991]

Hi ,

This link will help :

https://sites.google.com/site/e90e50/user/calcolo-combinatorio

It is in Italian , but there are downloadable workbooks.

Narayan

 

[Abhijeet R. Joshi]

I have not checked the attached files in the below link, but have similar query like yours..
http://www.excelforum.com/excel-general/681079-all-permutations-and-combinations.html

 

[FBB]

Hi Kchiba,

I'm looking for all combinations (order doesn't matter) of A, B, C including groups of 1 item, 2 items or 3 items.
You are correct -- I was missing B, C and <null>. The spreadsheets and links below actually don't address this problem/I'm not smart enough to figure out how to modify them to address this issue.

A, B, C
A, C
A, B
B, C
A
B
C
<null>

A, B, C has 8 solutions
A, B, C, D has 16 solutions.
A, B, C, D, E has 32 solutions.
A, B, C, D, E, F has 64 solutions.

Hi FBB,
aoubt that you have captured all the possible results from A,B,C, for example

B, C, A
A, C, B
etc.


kanti