LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
stuhag
 
Posts: n/a
Default referencing the cell above

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Referencing cell in another sheet yields null? [email protected] Excel Worksheet Functions 4 November 18th 05 01:11 AM
referencing Excel sheet name in cell Graham Tritton Excel Worksheet Functions 1 October 14th 05 06:53 AM
Another question re cell referencing. rmellison Excel Discussion (Misc queries) 0 September 23rd 05 12:10 PM
HYPERLINK IF referencing the cell of the function.. sans Excel Worksheet Functions 0 September 17th 05 02:08 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM


All times are GMT +1. The time now is 02:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"