Re: Extend formats and formulas

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Hi,

I have just trying to figure out the extend formats and formulas
feature for a family member. The feature will not extend a formula that
has been copy/pasted into the row. To avoid having to type a formula in
each time you need to use Fill/Down instead of copy paste. I also have
found that if the formula uses more than 2 columns you need 5
consectutive rows in order to get the sum to automatically appear. I
also was able to successfully get a simple formua like =G2-G1 to
automatically extend by using the previous tip of =G2-Offset(G2,-1,0).

In addition if the formula has even the simplest of differences such as
number formatting or even =sum(A1:G1) vs. =+sum(A1:G1) the extend won't
work (until there are 5 consecutive rows with the same formula).

Hope this helps you.

Jennifer


--
marisky23
------------------------------------------------------------------------
marisky23's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26736
View this thread: http://www.excelforum.com/showthread.php?threadid=397774

.

Relevant Pages

  • Re: list-like behaviour of etree.Element
    ... >> doesn't support pop and extend? ... Perhaps, submit a feature ... > request to Fredrik Lundh on SourceForge and see what he thinks there ... > is merit in more closely emulating the list API. ...
    (comp.lang.python)
  • About Interface and event
    ... The code below is a partial sample code that I get online. ... implement and extend the default feature. ...
    (microsoft.public.dotnet.general)
  • Re: Class herlper and inheritance
    ... like to extend ALL TCustomEdit desandt with tihs new feature .. ...
    (comp.lang.pascal.delphi.misc)
  • Re: About Interface and event
    ... I already have the application built that does the upload. ... THat's the default feature. ... "Mattias Sjögren" wrote: ... >>It actually implement and extend the default feature. ...
    (microsoft.public.dotnet.general)
  • Extend Formula not working
    ... Using Excel 2003 and have put a check mark next to the box to "extend data ... formula in Column E that calculates a running balance based on whatever is ... Now that I have gone back to that worksheet to enter new data in the next ... but the formula does not seem to automatically extend to the new row. ...
    (microsoft.public.excel)