Last Number in Column

Giganews Newsgroups
Subject: Last Number in Column
Posted by:  craig
Date: Wed, 4 Mar 2009

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

Replies