looking up the last value in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need assistance in choosing the correct function so that I can obtain the
last calculated value in a column range as each month another value is added
to the list.
 
=LOOKUP(9.99999999999999E+307,A:A)

would fetch the last numerical value from column A.
 
Dear Aladin
Thanks for your reply however this did not solve my problem. The column (T)
contains formulas which are dependent to other cells so if there is no value
in the other cells the result in column T is blank or zero. The function you
provided returns a value of "0" however I need a function that will return
the last value in column T that has a value >0. Thank you again for your
assistance.
 
U2:

=MATCH(9.99999999999999E+307)

V2: (the result cell)

=LOOKUP(2,1/(T2:INDEX(T:T,U2)>0),T2:INDEX(T:T,U2))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Excel VBA 1
Help calculating trend by colours/taking last value per month. Thanks for all efforts 0
Countif wrong in last row or two 3
Looking for Formula 1
sum and count text and numbers same column 1
retrieving values from a certain column 2
Field or formula to return last value in a column? 7

Back
Top