Offset Problem

[Tian1]

Hallo,

I've got the following data as an example in my sheet (see the table below). I'm trying to determine what the offset properties should be.

ROW	A	B	C	Answer
33	10	2	=A33-OFFSET(FROM B21 BY 12 ROWS)	8
34	11		=A34-OFFSET(FROM B21 BY 13 ROWS)	9
35	12		=A35-OFFSET(FROM B21 BY 14 ROWS)	10
			etc...
45	22	3	=A45-OFFSET(FROM B21 BY 24 ROWS)	19
46	23		=A46-OFFSET(FROM B21 BY 25 ROWS)	20
47	24		=A47-OFFSET(FROM B21 BY 26 ROWS)	21
			etc...

<tbody>
</tbody>

Any ideas?

Thanks!

 

[NeonRedSharpie]

Isn't "OFFSET FROM B21 BY 26 ROWS" just going to be row 47?

 

[Tian1]

Hi,

My apologies.. I framed the question wrong. It should be:

Cell C33: =A33-OFFSET(FROM B21 BY 12 ROWS)
Cell C34: =A34-OFFSET(FROM B21 BY 12 ROWS)
Cell C35: =A35-OFFSET(FROM B21 BY 12 ROWS)

Cell C45:=A45-OFFSET(FROM B21 BY 24 ROWS)
Cell C46:=A46-OFFSET(FROM B21 BY 24 ROWS)
Cell C47:=A47-OFFSET(FROM B21 BY 24 ROWS)

You can see the pattern that I'm after in this example.