Thread: I want to prevent a formula from being affected by insert line
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Erny Erny is offline
external usenet poster
  
Posts: 12
Default I want to prevent a formula from being affected by insert line
Actually I would prefer using then:

=AVERAGE(A$1:OFFSET(A$1;9;0))
this will not be affected by inserting lines.

Kind regards,
Erny

"StiDude" schrieb im Newsbeitrag
...
I have a formula which is average A1 to A10
When i insert a line in A1 it modifies the formula
to avegare A2-A12 but I want it NOT to change.

Any suggestions ?

Thanks


Reply With QuoteReply With Quote