二項相同 取最近日期 (11479)

K5:N6{=OFFSET($A$1,RIGHT(MAX(($C$5:$C$13=$I5)*($D$5:$D$13=$J5)*($B$5:$B$13/1%+ROW($5:$13))),2)-1,MATCH(K$4,$4:$4,)-1)

另解=LOOKUP(,0/FREQUENCY(0,9^9-$B$5:$B$13*($C$5:$C$13&$D$5:$D$13=$I5&$J5)),OFFSET($A$5:$A$13,,MATCH(K$4,$B$4:$G$4,)))