Thread: MIN >0
View Single Post
  #5   Report Post  
Myrna Larson
 
Posts: n/a
Default

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