Hello,

I have got 4 groups of 5 numbers as follow...

Group1-In the column "B" with 5 numbers

Group2-In the column "C" with 5 numbers

Group3-In the column "D" with 5 numbers

Group4-In the column "E" with 5 numbers

In fact using 20 numbers and making sets of numbers there must be total combinations =COMBIN(20,5) = 15.504

But I want to limit that the to make the set of 5 numbers it must pick 1 number from any of 3 groups and the 2 numbers from any of 1 group... I am not sure how much total combinations will be produce using this way

Please see the attached image example for more information

Please suggest VBA

Thank you all.

I am using Excel 2000

Regards,

Moti

I have got 4 groups of 5 numbers as follow...

Group1-In the column "B" with 5 numbers

Group2-In the column "C" with 5 numbers

Group3-In the column "D" with 5 numbers

Group4-In the column "E" with 5 numbers

In fact using 20 numbers and making sets of numbers there must be total combinations =COMBIN(20,5) = 15.504

But I want to limit that the to make the set of 5 numbers it must pick 1 number from any of 3 groups and the 2 numbers from any of 1 group... I am not sure how much total combinations will be produce using this way

Please see the attached image example for more information

Please suggest VBA

* | A | B | C | D | E | F | G | H | I | J | K | L | M |

1 | |||||||||||||

2 | |||||||||||||

3 | |||||||||||||

4 | Group 1 | Group 2 | Group 3 | Group 4 | n1 | n2 | n3 | n4 | n5 | ||||

5 | 1 | 17 | 27 | 44 | 1 | 3 | 17 | 27 | 44 | ||||

6 | 3 | 18 | 32 | 45 | 1 | 17 | 18 | 27 | 44 | ||||

7 | 5 | 22 | 36 | 47 | 1 | 12 | 22 | 32 | 47 | ||||

8 | 8 | 24 | 42 | 48 | 12 | 24 | 36 | 42 | 48 | ||||

9 | 12 | 25 | 43 | 50 | 1 | 22 | 36 | 47 | 48 | ||||

10 | 8 | 25 | 27 | 36 | 48 | ||||||||

11 | 5 | 22 | 32 | 42 | 47 | ||||||||

12 | |||||||||||||

13 | |||||||||||||

14 | |||||||||||||

15 | |||||||||||||

16 |

Thank you all.

I am using Excel 2000

Regards,

Moti