Thread: MIN >0
View Single Post
  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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))