J
Jocko_MacDuff116
I am trying to display the value from 2 rows above in the currently active
cell.
for example display in active cell c15 the value from c13 (15-2=13)
If I insert 4 new rows after c13 [ c14,c15,c16,c17 ]
I then want the value of C17 to be displayed in C19(the former c15)
What is the formula to do this?
Dynamically change the value of the active cell the value to display the
value of the cell 2 rows above
cell.
for example display in active cell c15 the value from c13 (15-2=13)
If I insert 4 new rows after c13 [ c14,c15,c16,c17 ]
I then want the value of C17 to be displayed in C19(the former c15)
What is the formula to do this?
Dynamically change the value of the active cell the value to display the
value of the cell 2 rows above