The following formula will return the last non-zero number in cells
A1:A20 --

=INDEX(A:A,MAX((A1:A200)*ROW(INDIRECT("1:20"))))

It's an array formula -- type the formula in the cell, then hold the
Ctrl + Shift keys, and press the Enter key.

Bill H. wrote:
Is there a formula that can return the last non-zero number in a column of
numbers?

I have a column of numbers that I add to daily, and I need to know the value
of the last number in that column for use in another formula.

Thanks!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html