Count last nonzero number in a column

J

Jeff

Hi

I have columns of numbers, A:Z. Each column has either numbers, zero's, or
text.
I need to find the row number that has the "Last" nonzero number.

So if A1="car" , A2=0, A3=6, A4="Boat"

I would need a value of 3, the last occurence of a nonzero number (6).

Thanks for your help
 
F

Frank Kabel

Hi
try the following formula:
=LOOKUP(2,1/((A1:A100<>0)*(ISNUMBER(A1:A100))),ROW(A1:A100))
 
Top