MIN >0

N

Neil

How do I get this to tell me when column B MIN >0
=INDEX(A2:A367,MATCH(MIN(B2:B367),B2:B367,0))
 
F

Frank Kabel

Hi
try the following array formula (entered with CTRL+SHIFT+ENTER):
=INDEX(A2:A367,MATCH(MIN(IF(B2:B367>0,B2:B367)),B2:B367,0))
 
J

JE McGimpsey

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:B367>0,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")
 
N

Neil

-----Original Message-----
Hi
try the following array formula (entered with CTRL+SHIFT+ENTER):
(B2:B367>0,B2:B367)),B2:B367,0))

--
Regards
Frank Kabel
Frankfurt, Germany


.
Thank You Frank, it worked.
Click to expand...
 
M

Myrna Larson

I don't understand your question.

The formula doesn't return the minimum from column B. It returns information
from column A, from the row that contains the minimum value in column B.

If you want to know what that minimum is, the formula is simply =MIN(B2:B367)
 
Top