Home |
Search |
Today's Posts |
#1
|
|||
|
|||
troubleshoot absolute value
I'm trying to have a cell (e.g. A19) reference a certain cell value (e.g.
from A3) and for that cell (A19) to maintain the same value from A3 after adding another row above A3. I've put in $A$3 in cell A19, but once I add a row above the third row, the now A20 automatically changes to ($A$4). How do I keep the absolute value? |
#2
|
|||
|
|||
troubleshoot absolute value
Try this one:
=INDIRECT("A3") |
#3
|
|||
|
|||
troubleshoot absolute value
How about:
A19: =INDIRECT("A3") Does that help? -- Regards, Ron "Sus" wrote: I'm trying to have a cell (e.g. A19) reference a certain cell value (e.g. from A3) and for that cell (A19) to maintain the same value from A3 after adding another row above A3. I've put in $A$3 in cell A19, but once I add a row above the third row, the now A20 automatically changes to ($A$4). How do I keep the absolute value? |
#4
|
|||
|
|||
troubleshoot absolute value
=INDIRECT("A3")
-- HTH RP (remove nothere from the email address if mailing direct) "Sus" wrote in message ... I'm trying to have a cell (e.g. A19) reference a certain cell value (e.g. from A3) and for that cell (A19) to maintain the same value from A3 after adding another row above A3. I've put in $A$3 in cell A19, but once I add a row above the third row, the now A20 automatically changes to ($A$4). How do I keep the absolute value? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making multiple cells absolute at once | Excel Discussion (Misc queries) | |||
replace absolute references | Excel Worksheet Functions | |||
replace absolute references | Excel Worksheet Functions | |||
Absolute cell references and subsequent problems. | Excel Discussion (Misc queries) | |||
Trouble with making a 3D reference absolute | Excel Discussion (Misc queries) |