Help!!!

[jimithing1980]

This issue is similar to absolute/relative references, but it's related to the data being referenced, not the cells doing the referencing. If I have a cell that references A3 then I insert a row above row 3 (making 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 or removed above row 3?

[Jon Quixley]

Jimithing1980,

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

Cheers
Jon

[SimonCC]

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

-Simon

"jimithing1980" wrote:

>
> This issue is similar to absolute/relative references, but it's related
> to the data being referenced, not the cells doing the referencing. If I
> have a cell that references A3 then I insert a row above row 3 (making
> 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 or
> removed above row 3?
>
>
> --
> jimithing1980
> ------------------------------------------------------------------------
> jimithing1980's Profile: http://www.excelforum.com/member.php...o&userid=36442
> View this thread: http://www.excelforum.com/showthread...hreadid=562097
>
>