Generate all possible combinations|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi All Excel Ninjas,

This is my 1st post here, below here is my problem.

I have data in two columns. Column A1 - A6 contains : AA, BB, CC, DD, EE, FF. And column B1-B3 contains +1, -1, 0

In column C and D, I want to populate the following - 

1st scenario:

Col C    Col D

AA       +1

BB       +1

CC       +1

DD      +1

EE       +1

FF       +1

2nd scenario:

Col C    Col D

AA       -1

BB       +1

CC       +1

DD      +1

EE       +1

FF       +1

3rd scenario:

Col C    Col D

AA       0

BB       +1

CC       +1

DD      +1

EE       +1

FF       +1

4th scenario:

Col C    Col D

AA       +1

BB       -1

CC       +1

DD      +1

EE       +1

FF       +1

5th scenario:

Col C    Col D

AA       +1

BB       -0

CC       +1

DD      +1

EE       +1

FF       +1

so on and so forth

So essentially, I want to populate all possible combinations where AA - FF remains constant while +1,-1 and 0 changes for those 6 elements (AA - FF) in different combinations.

Hope my query is clear. Looking forward to your help.

Regards,

D