#### Marc Wylie

##### New Member

- Joined
- Jun 26, 2015

- Messages
- 36

I am currently in the idle of my MSc Dissertation and have a huge problem. I know what I need Excel to do for me but I have n idea where to start.

I need to list all possible combinations of the following:

six different categories of aircraft to which I have allocated the following numbers (why these numbers is not important to solving the problem):

1

3

7

17

27

37

There are 23 regulations which must each have the applicable category dependant upon the aircrafts attributes placed into it.

So my problem is I need Excel to calculate and list every possible combination of the six aircraft categories over 23 columns starting like below:

1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1

1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 3

1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 3 3

1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 3 3 3

and on and on until infinity and beyond (well until all possible combinations have been calculated. I can then remove duplications and use the data for what I need.

Please be gentle as I am a complete excel novice but I need help in solving this pretty quickly so I don't waste to much time on data entry and can get on with the important bit of writing my dissertation!

Many thanks in advance for all your help and time.

Marc Wylie