Thread: Combinations of 4 variables with 3 values each

Hi, I'm pretty new to Excel and am trying to find a way to automatically generate all possible combinations (order not important) of 4 variables (A, B, C, D) with 3 values (1, 2, 3) each.

So there are only 12 possible variable+values:

A1, A2, A3, B1, B2, B3, C1, C2, C3, D1, D2, D3


Each combination must have one instance of each variable.

For example:

A1, B2, C3, D1
A2, B3, C1, D3

I think there are 81 different combinations, and I want to put them in 81 rows and then drag a formula down the next column to apply to each row.

Thanks in advance for any help....

Here, see this:

zbor, just what I needed, thanks!

I don't understand the formula off the bat, but I will see if I can try to learn what you did.