Hi
try the following array formula (entered with cTRL+SHIFT+eNTER):
=INDEX(A1:A100,MATCH(MIN(IF(YEAR(A1:A100)=2004,B1: B100)),B1:B100,0))

--
Regards
Frank Kabel
Frankfurt, Germany


gregl wrote:
2 columns of data:
Column A has dates from 1/1/70 onward (in chronological order).
Column B has a golf handicap as of the date in column A (in no
order -
varies up or down).
I use the DMIN function to find the lowest handicap in Column B for
each calendar year (based on range of dates in Column A).
My question is, how do I find the date in Column A that corresponds
to the lowest handicap in Column B for the given calendar year. (I
want to exclude the dates from other years that had the same
handicap.)