Thread: MIN >0
View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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