=INDIRECT("A"&MAX(IF(NOT(ISBLANK(A1:A100)),ROW(1:1 00))))

It's an array formula, so enter with Ctrl-Shift-Enter.

--

HTH

Bob Phillips

"Apfreight" wrote in message
...
Searching for a command that will show me the LAST value in a column. Not
the
largest, but the last. Any help0 greatly appreciated.