formula to return the last figure in a running total
hello
hopefully someone can help me out there!!!
I need a formula to return the last figure in a running total column. is there anything that can do that!!?
im using it for a bank tracker so it will be always changing so I need it to return the latest balance on a summary page.
many thanks in advance.
Carol
To get the last number in column A try this formula
=LOOKUP(9.99E+307,A:A)
change the column letter as required
Audere est facere
=INDEX($H:$H,COUNTA($H:$H)) for column H.
This assumes that a) there are no blank cells amongst the running totals and b) that there is no data below the running total data.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
HI - thanks for your speedy replies!
TMShucks - your formula returns 0??!
but Daddylonglegs - that's perfect! thanks! I wont bother to ask why the random numbers!! maybe they all mean something!
THANKYOU anyway!
9.99E+307 is the largest number that XL can handle
aha! ok simple when u know
thanks!
I'd need to know what is in column H.
its text - as in a list of months. is that why!?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks