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.

There's a workbook that will do this at https://www.box.com/s/47b28f19d794b25511be

Davidaw,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

Originally Posted by the-heart-wants

Can anyone tell me the formula to generate this combination? The excel provided has fixed values like A B C D What if the varaibles are diffenr?

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread