Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
"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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |