=TEXT(MAX(IF($A$1:$A$12=H2,$F$1:$F$12)),"e/m/d")&" "&INDEX($E$1:$E$12&" "&$D$1:$D$12,MAX(IF($A$1:$A$12=H2,ROW($A$1:$A$12))))
=INDEX(TEXT($F$1:$F$12,"e/m/d")&" "&$E$1:$E$12&" "&$D$1:$D$12,MAX(IF($A$1:$A$12=H2,ROW($A$1:$A$12))))
两个数组公式都可以,如上图,具体根据实际数据变更公式