I2:L21{=IFERROR(VLOOKUP(SMALL(IF(MATCH($D$2:$D$13,$D:$D,)=ROW($2:$13),ROW($2:$13)),COUNTIF($H$2:$H2,$H2))&$H2,IF({1,0},MATCH($D$2:$D$13,$D:$D,)&$A$2:$A$13,B$2:B$13),2,),"")
另解{=IFERROR(INDEX(B:B,MATCH($H2&INDEX($D:$D,SMALL(IF($D$2:$D23<>$D$1:$D22,ROW($D$2:$D23)), COUNTIF($H$1:$H2,$H2))),$A$1:$A23&$D$1:$D23,)),"")
留言
張貼留言