need a formula

  • Thread starter Thread starter Bill H.
  • Start date Start date
B

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!
 
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.
 
thanks!


Debra Dalgleish said:
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.
Click to expand...
 
Back
Top