Help!!!

[jimithing1980]

This issue is similar to absolute/relative references, but it's relate
to the data being referenced, not the cells doing the referencing. If
have a cell that references A3 then I insert a row above row 3 (makin
the original A3 cell now A4), my reference automatically changes to A4
How can I force the reference to say A3 regardless of any rows added o
removed above row 3

 

[Jon Quixley]

Jimithing1980,

This is exactly the same thing - absolute references usually use
dollar sign infront of the row and column address _together_. Tr
experimenting with putting the $ sign in front of just the row or jus
the column reference and I think you discover your answer.

Cheers
Jo

 

[Guest]

In your formula, replace A3 with OFFSET(A1,2,0)

-Simon