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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Size & Position precision 0
Macro to Select text from a point given to a specific word 2
Goal Seeking via Excel 0
Internal Data Integrity (Type 4) Details Needed 1
How do I have a cell value define a dynamic named range? 15
Finding the weighted average of text that have been given values 1
Complex formula 0
Problem with formula for finding last greater than/less than or equal to value 2

Top