Re: [libreoffice-users] Calc: Finding data at end of column

On 02/26/2013 11:04 AM, Jay Lozier wrote:
> On 02/26/2013 01:19 PM, John R. Sowden wrote:
> > I create a lot of ledger spreadsheets, including date,doc 
> > no,item,debit,credit,balance,notes.
> > I have a formula in the balance column that tests for data in the 
> > item column to show the balance otherwise I put a space there 
> > [=if(c23="";"";g22+d23-e23)], so the balance does not display down 
> > the page.
> >
> > That said, I am trying to figure out how to put the last amount (not 
> > space) in the balance column  in a formula to display the balance at 
> > the top of the screen, refer to it in a consolidated sheet, etc.
> >
> > tia,
> > John
> John
>
> I assume you have a set of consolidated data cells. I would try 
> =sum(balance range).
When I described how I might use the data in the last cell, I wanted to 
be vague because I did not want a solution that would only work under 
specific circumstances.  Actually what I want is a formula/function that 
will give me the amount in the last cell in the column that has a 
numeric value.

Short answer to your question: no, I do not have a set of consolidated 
data cells.

your sum function seems to want to sum a series of cells.  I only want 
the numeric value in the last cell in a column.



--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted