Compare 2 series of columns (Combinations)
 

Hello

I would like to know if it is possible.


That is to say
The goal is to have less tickets of group 2 with the maximum of favorite
combinations


I have in group 1 a certain number of favorite combinations,
in group 2 of the series from 6 to 10 numbers.
I would please know for each series of group 2 that it combination is
found there
and how much for the series concernéd.Voir example in end
If there is a solution simpler I do not know it



a list of combinations in the columns BCDEF group 1
another list of digits 6 to 10 it depend in the columns IJKLMNOPQR.
group 2

- 2 to 5 that depends, for group 1 if there are 2 there will be 2 for
all the column of the group 1
- 6 to 10 digits for group 2, yew 6, there will be 6 for all group 2




More than 200 lines in each column


-Initially to copy the series of numbers of group 2 in a array
then to make the combinations according to the number of figure of
group 1
Redimensionner the array in foction of the number of figure of group
1 in order to be able to compare of the same tables dimension



The result obtained after combinations of group 2 must be compared
with all the combinations of group 1
with a meter to know combiens of combinations of group 1 are found
in the series of figures of the groupe2

If possible to copy in another sheet the series of figure of group 2
with below all the combinations which result from this that for all the
lines from group 2


GROUP 1 GROUPE 2


1 2 3 4 1 2 3 4 5 6
1 2 3 5
1 2 3 6
1 2 4 5
1 2 5 6

THE RESULT IN ANOTHER SHEET (6 ,4) =15 combinations
nb
1 2 3 4 5 6 5 <<<< the total in that series

1 2 3 4 1
1 2 3 5 1
1 2 3 6 1
1 2 4 5 1
1 2 4 6 0
1 2 5 6 1
1 3 4 5 0
1 3 4 6 0
1 3 5 6 0
1 4 5 6 0
2 3 4 5 0
2 3 4 6 0
2 3 5 6 0
2 4 5 6 0
3 4 5 6 0

thank you