last number in a column

Shorty · Mar 12, 2005

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 · Mar 12, 2005

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