last number in a column

[Shorty]

Can I have excel take the last number in a column of 31 rows, only if it's
not a zero. And return that number to a given cell?



Thank You

 

[JulieD]

Hi Shorty

this should work for you
=LOOKUP(2,1/(-A1:A31<>0),A1:A31)

for more details have a read of
http://www.xldynamic.com/source/xld.LastValue.html

Cheers
JulieD