Last Number in Column

  • Thread starter Thread starter Craig
  • Start date Start date
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
 
=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
 
Back
Top