MIN >0
 

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

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

--
Regards
Frank Kabel
Frankfurt, Germany


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

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

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

--
Regards
Frank Kabel
Frankfurt, Germany


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))
.
Thank You Frank, it worked.

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)


On Wed, 27 Oct 2004 10:50:51 -0700, "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))