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.
<tbody>
</tbody>
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.
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!