List of Combinations of 7 different objects

[Susie_S]

Hi everyone,

I have a list of 7 possibilities (A,B,C,D,E,F,G) all of which can be combined with each other from being alone (A) to all 7 combined (A,B,C,D,E,F,G). Is there a way in excel to generate a list of all the possible combinations? Order does not matter.

I think there should be about 255 different combinations but I can't figure out how to create that list.

Thanks for any assistance!

 

[mikerickson]

Consider a seven digit binary number, if there is a zero in the i'th place then the i't item is in that group

i.e.
0100110 represents B,E,F
1100110 represents A,B, E,F


There are 2^7 possibilities (Including the "none") result.

 

[Susie_S]

Consider a seven digit binary number, if there is a zero in the i'th place then the i't item is in that group

i.e.
0100110 represents B,E,F
1100110 represents A,B, E,F


There are 2^7 possibilities (Including the "none") result.

Hi mikerickson,

Thank you for your reply Does that mean there should only be 128 combinations? That is good news for me!

 

[mikerickson]

Pretty much, but it also implys that there's no need to list them all. Since its the same as counting, you don't need to write out each combination.