I have series of 1000 favorite combinations
pick 3 1000
pick 4 1000
pick 5 1000
pick 6 1000

ex: With the series of pick 3

I would like to convert them into combinations of 7 maximum

If I put value 7 in maximum,

the macro one must give me
_the combinations of 7 possible,
_then of 6,
_then of 5,
_then of 4,
_then of 3

If I put value 6 in maximum
_the combinations of 6 possible
_then of 5,
_then of 4,
_then of 3


the same combinations must be found in the modified combinations.

ex:
Comb 1: 1,2,3
Comb 2: 1,2,4
Comb 3: 1,2,5

the result a combination of 5

1,2,3,4,5

Comb 1: 1,2,3
Comb 2: 1,2,4
Comb 3: 1,2,5
Comb 3: 1,2,6

Another ex:
the result a combination of 6

1,2,3,4,5,6

The goal is to decrease the combinations but by finding about the same
ones.

I do not know if I were clearly

thank you


Dana DeLouis a écrit :
I have another question about the combinations, if it is possible.

Glad it worked. :)
Sure...What's your question?