Thread: How do you find first 0 or first postive value in array
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
N Harkawat N Harkawat is offline
external usenet poster
  
Posts: 55
Default 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
Reply With QuoteReply With Quote