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.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ROW
[/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]Answer
[/TD]
[/TR]
[TR]
[TD]33
[/TD]
[TD]10
[/TD]
[TD]2
[/TD]
[TD]=A33-OFFSET(FROM B21 BY 12 ROWS)
[/TD]
[TD]8
[/TD]
[/TR]
[TR]
[TD]34
[/TD]
[TD]11
[/TD]
[TD][/TD]
[TD]=A34-OFFSET(FROM B21 BY 13 ROWS)
[/TD]
[TD]9
[/TD]
[/TR]
[TR]
[TD]35
[/TD]
[TD]12
[/TD]
[TD][/TD]
[TD]=A35-OFFSET(FROM B21 BY 14 ROWS)
[/TD]
[TD]10
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]etc...
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]45
[/TD]
[TD]22
[/TD]
[TD]3
[/TD]
[TD]=A45-OFFSET(FROM B21 BY 24 ROWS)
[/TD]
[TD]19
[/TD]
[/TR]
[TR]
[TD]46
[/TD]
[TD]23
[/TD]
[TD][/TD]
[TD]=A46-OFFSET(FROM B21 BY 25 ROWS)
[/TD]
[TD]20
[/TD]
[/TR]
[TR]
[TD]47
[/TD]
[TD]24
[/TD]
[TD][/TD]
[TD]=A47-OFFSET(FROM B21 BY 26 ROWS)
[/TD]
[TD]21
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]etc...
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Any ideas?
Thanks!
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.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ROW
[/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]Answer
[/TD]
[/TR]
[TR]
[TD]33
[/TD]
[TD]10
[/TD]
[TD]2
[/TD]
[TD]=A33-OFFSET(FROM B21 BY 12 ROWS)
[/TD]
[TD]8
[/TD]
[/TR]
[TR]
[TD]34
[/TD]
[TD]11
[/TD]
[TD][/TD]
[TD]=A34-OFFSET(FROM B21 BY 13 ROWS)
[/TD]
[TD]9
[/TD]
[/TR]
[TR]
[TD]35
[/TD]
[TD]12
[/TD]
[TD][/TD]
[TD]=A35-OFFSET(FROM B21 BY 14 ROWS)
[/TD]
[TD]10
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]etc...
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]45
[/TD]
[TD]22
[/TD]
[TD]3
[/TD]
[TD]=A45-OFFSET(FROM B21 BY 24 ROWS)
[/TD]
[TD]19
[/TD]
[/TR]
[TR]
[TD]46
[/TD]
[TD]23
[/TD]
[TD][/TD]
[TD]=A46-OFFSET(FROM B21 BY 25 ROWS)
[/TD]
[TD]20
[/TD]
[/TR]
[TR]
[TD]47
[/TD]
[TD]24
[/TD]
[TD][/TD]
[TD]=A47-OFFSET(FROM B21 BY 26 ROWS)
[/TD]
[TD]21
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]etc...
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Any ideas?
Thanks!