If I understand you correctly, you want to return the value in column A
that corresponds to the the minimum value in column B that is greater
than 0. If so, here's one way (array-entered):
=INDEX(A2:A367,MATCH(MIN(IF(B2:B3670,B2:B367)),B2 :B367,FALSE))
If, OTOH, you just want to know if the Minimum value in column B is
greater than 0, try:
=MIN(B2:B367) 0
which returns TRUE or FALSE, or perhaps
=IF(MIN(B2:B367)0, "MIN 0", "MIN <=0")
In article ,
"Neil" wrote:
How do I get this to tell me when column B MIN 0
=INDEX(A2:A367,MATCH(MIN(B2:B367),B2:B367,0))
|