find first positive value in a range

S

Shane

Hi all, is there a formula i can use to find the first positive value in a
given range??

Thansk
SK
 
D

Daniel.M

Hi Shane,

If you're having your data in one column, here's one way, with an ARRAY formula
(Ctrl-Shift-Enter):

=INDEX(data,MATCH(TRUE,data>0,0))

Regards,

Daniel M.
 
S

Shane

thank you kindly.


Daniel.M said:
Hi Shane,

If you're having your data in one column, here's one way, with an ARRAY formula
(Ctrl-Shift-Enter):

=INDEX(data,MATCH(TRUE,data>0,0))

Regards,

Daniel M.
Click to expand...
 
Top