J
Jocko_MacDuff116
Does anyone know the formula to ALWAY display the value in the active cell
which is 2 rows above it?
For example: Display in Active cell c13 the value in c11 (row13-2=row11).
The problem comes if I were to insert 4 rows after c11 and insert more data.
I would subsequently want to display in c17 (13+4) the value from c15 which
is 2 rows above it.
An absolute cell reference is not the same as saying a constant of 2 rows
above the active cell?
Any ideas to share??
which is 2 rows above it?
For example: Display in Active cell c13 the value in c11 (row13-2=row11).
The problem comes if I were to insert 4 rows after c11 and insert more data.
I would subsequently want to display in c17 (13+4) the value from c15 which
is 2 rows above it.
An absolute cell reference is not the same as saying a constant of 2 rows
above the active cell?
Any ideas to share??