That doesn't work if there are duplicate hdcp's.
The following ARRAY formula (Ctrl-Shift-Enter):
aYear: 1972
Dates: Your range of Dates
hdcps: Your range of handicaps.
=INDEX(hdcps,MATCH(1,(YEAR(Dates)=aYear)*
(hdcps=MIN(IF(YEAR(Dates)=aYear,hdcps))),0))
Regards,
Daniel M.
|