Hi guys,

Need piece of advice.

I have to get the last number from the row that is more than 0. Sounds
a little complicated but actually it is for example:

CEll A1 - 10
CEll A2 - 0
CEll A3 - 15
CEll A5 - 0

In Cell A5 I should have 15.

Does somebody have any idea how to get it?

Thanks a lot in advance,

Irina.


--
Irina
------------------------------------------------------------------------
Irina's Profile: http://www.excelforum.com/member.php...fo&userid=8685
View this thread: http://www.excelforum.com/showthread...hreadid=528257