F2:F9{=INDEX(A:A,MIN(IF(COUNTIF(F$1:F1,A$2:A$11)=0,ROW($2:$11),99)))&""
G2:J9{=INDIRECT(TEXT(SMALL(IF($A$2:$A$11=$F2,ROW($2:$11)/1%+{2,3},9999),COLUMN(A1)),"!R0C00"),)&""
另解G2:J9{=OFFSET($A$1,SMALL(IF(($A$2:$A$11=$F2)*($B$1:$C$1=G$1),ROW($1:$10),99),COLUMN(B1)/2),(G$1=$H$1)+1)&""
留言
張貼留言