Let's say your balance is in column A from A2 to somewhere below.
Put in A1

=LOOKUP(2,1/(A2:A653560),A2:A65356)

(suggested by Sandy Mann)
--
Gary's Student


" wrote:

I have a very simple checkbook register. I would like to be able to
display
the ending balance in a specific cell at the top of the sheet. How can
I do this?

Thanks