Permutation in excel
 

Hallo!

I´me a new member in your forum, can somebody help me to solve this
problem in excel please:

I need to make combinations with a makro or a funktion in excel as
followed:

Combinations with 7 numbers from 1 - 35 like that:

1 2 3 4 5 6 7
1 2 3 4 5 6 8
1 2 3 4 5 6 9

and so on, the last combination in this serie is:

1 2 3 4 5 6 35

Next serie:
1 2 3 4 5 7 8
1 2 3 4 5 7 9
1 2 3 4 5 7 10

And so on, the last combination in this serie is:

1 2 3 4 5 7 35

Next serie:

1 2 3 4 5 8 9
1 2 3 4 5 8 10
1 2 3 4 5 8 11

Until the last combination is:

1 30 31 32 33 34 35

Anyone who can help?


--
Sweden
------------------------------------------------------------------------
Sweden's Profile: http://www.excelforum.com/member.php...o&userid=27322
View this thread: http://www.excelforum.com/showthread...hreadid=468222

"Sweden" wrote...
....
Combinations with 7 numbers from 1 - 35 like that:

1 2 3 4 5 6 7
1 2 3 4 5 6 8
1 2 3 4 5 6 9

and so on, the last combination in this serie is:

1 2 3 4 5 6 35

Next serie:
1 2 3 4 5 7 8
1 2 3 4 5 7 9
1 2 3 4 5 7 10

And so on, the last combination in this serie is:

1 2 3 4 5 7 35
....
Until the last combination is:

1 30 31 32 33 34 35
....

In other words you need 1 followed by all (ordered) combinations of 6
integers drawn from 2..35. There are 1,344,904 such combinations, so bj's
macro if extended to the original problem will fail at the 65,537th
combination. How would you want these arranged?