Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help!!!
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help!!!
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 -- Jon Quixley ------------------------------------------------------------------------ Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803 View this thread: http://www.excelforum.com/showthread...hreadid=562097 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help!!!
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|