Formula to get MAX non-zero value from bottom up

[rizmomin]

Hello:

Please refer to attached file.
I need formula in cell B15, which will give 1st non-zero value from cell B12 up to B1
In this case answer needs to be 644.54

Assume if i have put B9 = 700, then answer will need to change to 700

Tried using below but did not work:

Please Login or Register  to view this content.

Let me know if you have any questions.
Thanks.
Riz

[63falcondude]

Try this:

=LOOKUP(2,1/(B1:B12<>0),B1:B12)

[Root_]

First non-zero value from cell B12 up to B1 is the same as the last non-zero value in range B1:B12 -- so, try

=LOOKUP(2,1/(B1:B12>0),B1:B12)

[rizmomin]

Hello 63falocn & Root:

Works great

Thanks

Riz

[63falcondude]

Happy to help, thanks for the rep!