Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
I have a kin a formula wich gets the value from the cell above and then add some. What I get is an list of values incrementing. When I delete one row in this list, all cells below 'crashes' with #REF!. What I need is that for the formulas to always look one cell up, even if I delete a row. Now it seems that if I delete Row8, then when Row9 become Row8 it reference to it self and then ov course goes bananas... Hope I made myself understandable ;-) Any ideas folks? -------- stuhag --------- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Referencing cell in another sheet yields null? | Excel Worksheet Functions | |||
referencing Excel sheet name in cell | Excel Worksheet Functions | |||
Another question re cell referencing. | Excel Discussion (Misc queries) | |||
HYPERLINK IF referencing the cell of the function.. | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions |