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

-------- Original Message  --------
From: John R. Sowden <jsowden@americansentry.net>
To: users@global.libreoffice.org
Date: Tue, 26 Feb 2013 10:19:45 -0800

> 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

Hi John,

For a range A1:A10 you could use =INDEX(A1:A10,COUNT(A1:A10)) in the
target cell.

HTH

Dave


-- 
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