How to get LAST value of the column

[hsandeep]

My values are NUMERICALS (-ve, 0 or +ve) in C2:C9999
In B2, I want LAST value of the column C2:C9999 & it must be +ve.
How to accomplish?
Thanx in adv

 

[Aladin Akyurek]

=LOOKUP(9.99999999999999E+307,1/(ISNUMBER(C2:C9999)*(C2:C9999>0)),C2:C9999)

IT WORKS. I'll check again & inform you tomorrow as well.[/QUOTE]

IT WORKS. Thanks[/QUOTE]

You are welcome. Thanks for the update.