need a formula

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!
--
Bill

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

thanks!


"Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
news:4029A319.2040404@contexturesXSPAM.com...
> 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. 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
>