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