Hi Irina,

Something like this ...

=LOOKUP(2,1/(A1:A50),ROW(A1:A5))

Change the range (A1:A5) to suit.

HTH

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"Irina" wrote in
message ...

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