C3:E8{=IFERROR(INDEX(TRIM(MID(SUBSTITUTE($B$3:$B$10,"/",REPT(" ",99)),COLUMN($A:$I)*99-98,99)),SMALL(IF(($A$3:$A$10=C$2)*(TRIM(MID(SUBSTITUTE($B$3:$B$10,"/",REPT(" ",99)),COLUMN($A:$I)*99-98,99))<>"")*(COUNTIF(C$2:C2,TRIM(MID(SUBSTITUTE($B$3:$B$10,"/",REPT(" ",99)),COLUMN($A:$I)*99-98,99)))=0),ROW($1:$8)),1),RIGHT(SMALL(IF(($A$3:$A$10=C$2)*(TRIM(MID(SUBSTITUTE($B$3:$B$10,"/",REPT(" ",99)),COLUMN($A:$I)*99-98,99))<>"")*(COUNTIF(C$2:C2,TRIM(MID(SUBSTITUTE($B$3:$B$10,"/",REPT(" ",99)),COLUMN($A:$I)*99-98,99)))=0),ROW($1:$8)/1%+COLUMN($A:$I)),1))),"")
K3:S10=TRIM(MID(SUBSTITUTE($B3,"/",REPT(" ",99)),COLUMN(A1)*99-98,99))
G3:I8{=IFERROR(INDIRECT(TEXT(MIN(IF((COUNTIF(G$2:G2,$K$3:$S$10)=0)*($K$3:$S$10<>"")*($A$3:$A$10=G$2),ROW($3:$10)/1%+COLUMN($K:$S))),"!R0C00"),),"")
留言
張貼留言