Combinations of diffferent groups

mrc44

Board Regular
Joined
Aug 12, 2017
Messages
54
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

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Watch MrExcel Video

Forum statistics

Threads
1,113,890
Messages
5,544,878
Members
410,643
Latest member
sng
Top