Running Balance show at top

  • Thread starter Thread starter SharonSmith
  • Start date Start date
S

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.
 
In the cell at the top, enter the following formula:

=INDEX(D1:D65535,MAX(ROW(D1:D65535)*(D1:D65535<>"")))

with <Ctrl> <Shift> <Enter> instead of just <Enter>. This assumes D is the
column of interest.
 
Hi
try
=VLOOKUP(9.999999E307,A1:A10000,1)
if you want the last numeric value from column A
 
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.
 
Back
Top