Remember Me?

#1
October 27th 04, 06:50 PM
 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))

#2
October 27th 04, 07:01 PM
 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))

#3
October 27th 04, 07:09 PM
 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))

#4
October 27th 04, 07:12 PM
 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.

#5
October 27th 04, 07:46 PM
 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))

 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 10:58 PM.