I like that better!
Art
"JE McGimpsey" wrote:
A technique that survives adding a top row:
=formula(INDIRECT("B4"))
In article ,
Art wrote:
If I understand, you're adding a row higher than B4. This shifts B4 down,
but you want the "new" B4 to be the data for the formula. If this is the
case you could try this:
=formula(OFFSET(A1,3,1,1,1))
That is, as long as you don't add a new top row.
|