Hi,
I'm looking for a formula that will reutrn the last non-zero value in a row.
TIA.
--
Ken Hudson

Based on your question I'm assuming only numbers will involved, no TEXT in
the range?

=LOOKUP(2,1/(1:1<0),1:1)

Will return the last value that is not a zero from row 1, A1:IV1.

Biff

"Ken Hudson" wrote in message
...
Hi,
I'm looking for a formula that will reutrn the last non-zero value in a
row.
TIA.
--
Ken Hudson

Here's a variation of Biff's formula that you can put in A1 (and copy down)
to check the rest of the row..........

=IF(MAX(B1:IV1)0,LOOKUP(2,1/(B1:IV1<0),B1:IV1),"")

Vaya con Dios,
Chuck, CABGx3



"Ken Hudson" wrote:

Hi,
I'm looking for a formula that will reutrn the last non-zero value in a row.
TIA.
--
Ken Hudson

Biff,
Thanks for the solution. It works as advertised.
I am trying to undersand the logic.
Is the first "2" Boolean (i.e. "False")?
Is the first "1" Boolean (i.e. "True")?
The formula seems to work whether the "1" is a "1" or a "2."
If you have a moment, could you explain how this works?
(Always trying to improve my Excel logic skills.)
Thanks.

--
Ken Hudson


"Ken Hudson" wrote:

Hi,
I'm looking for a formula that will reutrn the last non-zero value in a row.
TIA.
--
Ken Hudson

See this:

http://xldynamic.com/source/xld.LastValue.html

Scroll (about half way down the page) to this section:

#012 - Using A Non-Array LOOKUP Formula

It explains how the basic formula works.

Biff

"Ken Hudson" wrote in message
...
Biff,
Thanks for the solution. It works as advertised.
I am trying to undersand the logic.
Is the first "2" Boolean (i.e. "False")?
Is the first "1" Boolean (i.e. "True")?
The formula seems to work whether the "1" is a "1" or a "2."
If you have a moment, could you explain how this works?
(Always trying to improve my Excel logic skills.)
Thanks.

--
Ken Hudson


"Ken Hudson" wrote:

Hi,
I'm looking for a formula that will reutrn the last non-zero value in a
row.
TIA.
--
Ken Hudson