Thread: MIN >0
View Single Post
  #4   Report Post  
Neil
 
Posts: n/a
Default


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