Posted to microsoft.public.excel.programming
|
|
Permutation in excel
http://tinyurl.com/dxm5u
--
Regards,
Tom Ogilvy
"Sweden" wrote in
message ...
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=468161
|