# List of Combinations of 7 different objects

#### Susie_S

##### New Member
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!

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

#### mikerickson

##### MrExcel MVP
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

##### New Member
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

##### MrExcel MVP
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.

Replies
22
Views
590
Replies
22
Views
419
Replies
1
Views
114
Replies
2
Views
174
Replies
12
Views
659

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,545
Messages
5,832,387
Members
430,129
Latest member
EmilyCrandall

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back