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=468223

That would require a VB script.

"Sweden" wrote:


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=468223

One more thing, excel will quickly run out of room.

"Sweden" wrote:


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=468223

See responses at your multi-post in microsoft.public.excel
(Please do not multipost .. )
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

Hi,

In cells A1, B1, ... G1, enter 1, 2, ... 7. In A2, B2, ... G2, enter the
following formulas.

In A2, =IF(AND(B1=30,C1=31,D1=32,E1=33,F1=34,G1=35),"End" ,1)
In B2, =IF(C1=31,IF(B1=30,A2+1,B1+1),B1)
In C2, =IF(D1=32,IF(C1=31,B2+1,C1+1),C1)
In D2, =IF(E1=33,IF(D1=32,C2+1,D1+1),D1)
In E2, =IF(F1=34,IF(E1=33,D2+1,E1+1),E1)
In F2, =IF(G1=35,IF(F1=34,E2+1,F1+1),F1)
In G2, =IF(G1=35,F2+1,G1+1)

Drag the formulas down the rows. However, note that you will quickly run
out of room and memory.

For example, in row 65536, it was 1, 2, 4, 19, 27, 30, 32! There is no way
you would be able to reach 1, 30, 31, 32, 33, 34, 35.

Regards,
B.R. Ramachandran


"Sweden" wrote:



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=468223