In a column of numbers, how do I return the last non-zero number?

[ACEACE]

That is the bottom-most non-zero number?

[Biff]

Hi!

>In a column of numbers

Try this:

=LOOKUP(2,1/(A1:A10<>0),A1:A10)

Biff

"ACEACE" <[email protected]> wrote in message
news:[email protected]...
> That is the bottom-most non-zero number?

[CLR]

That seems to return only the value in A10.........

Perhaps this........
=SMALL(A1:A10,COUNTIF(A1:A10,0)+1)

Vaya con Dios,
Chuck, CABGx3





"Biff" wrote:

> Hi!
>
> >In a column of numbers
>
> Try this:
>
> =LOOKUP(2,1/(A1:A10<>0),A1:A10)
>
> Biff
>
> "ACEACE" <[email protected]> wrote in message
> news:[email protected]...
> > That is the bottom-most non-zero number?
>
>
>

[Biff]

Screencap:

http://img519.imageshack.us/img519/1...nonzero6xy.jpg

Biff

"CLR" <[email protected]> wrote in message
news:[email protected]...
> That seems to return only the value in A10.........
>
> Perhaps this........
> =SMALL(A1:A10,COUNTIF(A1:A10,0)+1)
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
>
>
> "Biff" wrote:
>
>> Hi!
>>
>> >In a column of numbers
>>
>> Try this:
>>
>> =LOOKUP(2,1/(A1:A10<>0),A1:A10)
>>
>> Biff
>>
>> "ACEACE" <[email protected]> wrote in message
>> news:[email protected]...
>> > That is the bottom-most non-zero number?
>>
>>
>>

[CLR]

My apology.......I kept reading "the bottom-most non-zero number" as being
"the smallest non-zero number".........

Vaya con Dios,
Chuck, CABGx3


"Biff" wrote:

> Screencap:
>
> http://img519.imageshack.us/img519/1...nonzero6xy.jpg
>
> Biff
>
> "CLR" <[email protected]> wrote in message
> news:[email protected]...
> > That seems to return only the value in A10.........
> >
> > Perhaps this........
> > =SMALL(A1:A10,COUNTIF(A1:A10,0)+1)
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> >
> >
> >
> > "Biff" wrote:
> >
> >> Hi!
> >>
> >> >In a column of numbers
> >>
> >> Try this:
> >>
> >> =LOOKUP(2,1/(A1:A10<>0),A1:A10)
> >>
> >> Biff
> >>
> >> "ACEACE" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > That is the bottom-most non-zero number?
> >>
> >>
> >>
>
>
>