Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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=468161 |
#2
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Permutation in excel | Excel Worksheet Functions | |||
Permutation in excel | Excel Worksheet Functions | |||
Permutation in excel | Excel Discussion (Misc queries) | |||
Permutation in excel | Excel Worksheet Functions | |||
Creating a Combination or Permutation Array in Excel | Excel Programming |