Last Number in Column

C

Craig

I have the following formula:

=Lookup(9.999e+307,A1:A44) which finds the last number in column A. What I
need now is a similar formual that will give me the last number in Column A
that is not 0. Column A is filled with formulas so often times the result of
the folrmula is 0. I want to be able to leave that out and selct the last
number greater than 0.

Thanks for your help
 
B

Bernard Liengme

=LOOKUP(9.999E+307,IF(A1:A44>0,A1:A44))
As this is an array formula, you need to commit it with SHIFT+CTRL+ENTER not
just ENTER
best wishes
 

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

lookup and return column number 2
Averageifs - criteria is cell is not blank 1
Last Value in a Column when Value <> 0 1
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Looking for the value that indicates last row number that has filled cells 3
Formula 1
How do I use "column" function to get the column number of the firstcell matching criteria? 1
Number series at end of column macro? 4

Top