Home |
Search |
Today's Posts |
#1
|
|||
|
|||
can I use GO TO results in a formula?
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? |
#2
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Can the results of a formula drive color shading? How? Can it be . | Excel Worksheet Functions | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) |