find first positive value in a range

  • Thread starter Thread starter Shane
  • Start date Start date
S

Shane

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

Thansk
SK
 
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.
 
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...
 
Back
Top