Thread
:
can I use GO TO results in a formula?
View Single Post
#
2
Biff
Posts: n/a
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?
Reply With Quote