Remember Me?

 Neil Posts: n/a 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))

 Frank Kabel Posts: n/a 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))

 JE McGimpsey Posts: n/a 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))

 Neil Posts: n/a -----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.

 Myrna Larson Posts: n/a 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))

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

All times are GMT +1. The time now is 03:08 AM. Copyright ©2004-2019 ExcelBanter.