Combinations of diffferent groups

mrc44

Board Regular
Joined
Aug 12, 2017
Messages
64
I have six groups of numbers, each group has three unique numbers.

I am looking for a way to generate 6 number combinations of 6 groups. The idea is to have ONLY one number from each group and generate all of the possible combinations that follow this rule.

How can I achieve this? I am also open to a formula solution if possible.Thanks!

Here is a sample file:

 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Watch MrExcel Video

Forum statistics

Threads
1,119,023
Messages
5,575,631
Members
412,680
Latest member
TSpan
Top