Hi
and what would be your expected result in these cases?

"Golfer" wrote:

That doesn't work if there are duplicate hdcp's.

1/1/1970 10
3/5/1970 9
1/1/1971 15
5/1/1971 12
1/1/1972 11
6/5/1972 10


using 1972 as the year, that formula returns 1/1/1970


-----Original Message-----
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.)

.