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