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

E

ExcelMonkey

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
 
N

N Harkawat

=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
 
Top