-------- Original Message -------- From: John R. Sowden <[email protected]> To: [email protected] 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: [email protected] 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
