start point: formula in col. B
directions: go to col. A, step upward 'til reach non-blank cell
end point: use contents of $A# inside the formula

I can physically find the required data using Go To (or even [End] +
arrow-up key)
but how can a get a formula to do this? or do I need a macro?

Hi!

This formula will retuen the last value in column A within the range
A1:A100:

=LOOKUP(2,1/(1-ISBLANK(A1:A100)),A1:A100)

Note: cannot use the entire column as the range argument - A:A

Biff

"having eXceLed, I now want aXeS" <having eXceLed, I now want
wrote in message
...
start point: formula in col. B
directions: go to col. A, step upward 'til reach non-blank cell
end point: use contents of $A# inside the formula

I can physically find the required data using Go To (or even [End] +
arrow-up key)
but how can a get a formula to do this? or do I need a macro?