need a function to report last value in a column

[ajju_khan]

Hi Brent



Try this simple formula. Hope it will help u. Reply me back. Thanks



=index(rangename:rangename,match(9.9999999999999E+307,rangename:rangename))

I need a function that will report the value of the last
filled cell in a range of cells or column.

The purpose is to show a "final balance" at the bottom of
a page that contains a running total of debits and
credits.

It seems ridiculously simple but I cannnot seem to find a
solution. I'm using Excel 97.

Brent