formula tu sum up to a number till 7

  • Thread starter Thread starter Diana
  • Start date Start date
D

Diana

This is the data I have:

2 3
4 5
5 6
6 7
7 1
4 5
1 2

I want in column C to G cells to be filled till 7 starting to count
from B and then starting again. Result I want:

A B C D E F G

2 3 4 5 6 7 1
4 5
5 6
6 7
7 1
4 5
1 2

And so on...

How can I do this...

Thank you so much!!!
 
I don't fully understand this. Why do you not show 2 as the starting
value in column C? Why do you have a 1 after the 7? Is this the
corresponding value from column B? Would C2 start with 4 and continue
across until you next came up with a 7?

Please explain the rules more clearly.

Pete
 
Hi, Pete

Thanks for your answer. The formula must add one up to the number of
column B and continue on in the rest of the row till 7. Then it has to
start on 1 again. It will be copied to the right on teh same row.

A B C D E F G
2 3 4 5 6 7 1
4 5 5 6 7 1 2
5 6
6 7
7 1
4 5
1 2


For example row 3, should go on C3 7 (cause this is the last number of
the series), on D3 it has to go to 1, then E3 3, F3 4 and G3 5.

Thanks in advance.
 
Still not clear.
A B C D E F G
2 3 4 5 6 7 1
4 5 5 6 7 1 2
5 6
6 7
7 1
4 5
1 2
Click to expand...

Why does C1 start with 4 and C2 start with 5?

Also, what should the sequence be for:
 
Hi,

Thanks for your effort. Because b3 is 3 and the series must go to the
right, not down. Anyway I´ve found the formula:

=IF(B2=6;1;IF(B2=7;2;B2+2))

Then drag to the right.

Thanks for your attention
 
In C1:
=mod(B1,7)+1

Copy to the right and down, so for example in G9 it reads:
=mod(F9,7)+1

HTH
Adam
 
Back
Top