need a formula

[Bill H.]

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]

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

=INDEX(A:A,MAX((A1:A20<>0)*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.]

thanks!

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

=INDEX(A:A,MAX((A1:A20<>0)*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.