Running Balance show at top

[SharonSmith]

I have a simple budget sheet where the remaining balance is the last value
in the column. But it's at the end and I must scroll down to see it. I'd
like it to be at the top also, in any column, so that I can see at a glance
how much I have left. How can I do this? Thanx for your help.

 

[Vasant Nanavati]

In the cell at the top, enter the following formula:

=INDEX(D165535,MAX(ROW(D165535)*(D165535<>"")))

with <Ctrl> <Shift> <Enter> instead of just <Enter>. This assumes D is the
column of interest.

 

[Frank Kabel]

Hi
try
=VLOOKUP(9.999999E307,A1:A10000,1)
if you want the last numeric value from column A

 

[Tess]

Hi:
Just pick a cell at the top where you want your balance to
show, type =plus the cell address that shows the balance
at the bottom. Just leave an extra row above the total to
accommodate insertion of additional rows where add'l items
are added.