On Fri, 27 May 2005 22:07:19 +0200, Ennio-Sr wrote: >* GregChi <[EMAIL PROTECTED]> [270505, 15:49]: >> On Thu, 26 May 2005 15:15:50 +0200, Ennio-Sr wrote: >> [...skip...] >> > >> >Hi Greg, >> >maybe you could put '=balance' in cell A1 and then, after entering all >> >your data, define col D? as a named range 'balance' ? I think you could > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ >> >also automate this with a macro. >> > >> >Regards, >> > Ennio. >> >> Where do you find 'balance' in the functions? (1.1.4 & 1.9.7.9 don't >> show this) >> Is this an addon? How would I go about making this? >> > >Hi Greg, >When I said "... define col D? as a named range ..." I was referring to >columun "D" (you indicate in your message) row "?" = unknown, i.e. the >last row in column D where the balance (or any other name you choose to >define that particular cell) would possibly be. >To define a range you select (in the upper bar) >Insert -> Names -> Define > >Hope to have been clear enough but feel freee to ask again in case >you are in trouble ;) >Regards, > Ennio.
OK, in the sample file "CheckRegister.sxc" the "Balance" column (F) has the formula " =IF(AND(ISBLANK(D8);ISBLANK(E8));"";F7-D8+E8) ". All of the cells in column F (1-32000) have this formula This is where I got the idea from. If cells F1-F400 have 'results' then they would have visible data. If cell F401 DOESN't have results then it would not have visible data. Therefore cell F400 would have the 'balance'. If more data were entered that cell would change. I was looking for a formula that would refer to the last cell with visible data in it. Maybe this is not possible & I would need to use George L. Minson's method..... Thanks all -- Greg Agent 1.93/32.576 Opera8 OOo 2(1979) news.readfreenews.net & news.gmane.org Win98se for sale: Apple//,Auto Parts/Equip/Manuals: http://[EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
