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

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

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

=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
"ExcelMonkey" wrote:

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