How do you find first 0 or first postive value in array

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an array of data which goes negative to positive. How do I locate the
first position within that array which is 0 or positive. Note that using
MATCH(0,Array.0) does not always work properly.

Thanks

EM
 
=MIN(IF((A2:A600>=0),ROW(A2:A600)))
array entered (ctrl+shift+enter)

Adjust the formula by adding or subtracting to get the right rel;atoive
position as agianst row numbers
 
You must log in or register to reply here.

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

INDEX function array causes problem when attempting to use LARGEfunction to sort positive and negati 10
Mapping integers to strings 5
multi-array sumproduct 6
How do I select a range? 2
Position of first number in array greater than a given number 4
INDEX & MATCH find first column value in an array? 3
using particular positions within an array 2
If statement only shows value in first cell 3

Back
Top