D3:D9{=IFERROR(INDEX(B:B,LOOKUP(SMALL(IF(A$3:A$15=E$2,ROW($3:$15)),ROW(A1)),IF(A$3:A$15=D$2,ROW($3:$15)))),"")
E3:F9{=INDEX($B:$B,SMALL(IF(($A$3:$A$15=E$2)*(LOOKUP(ROW(3:15),ROW(3:15)/($A$3:$A$15=$D$2),$B$3:$B$15)=$D3),ROW($3:$15),99),COUNTIF($D$3:$D3,$D3)))&""
留言
張貼留言