F2:F9{=INDEX($A:$A,SMALL(IF(LEN(B$2:B$4)-LEN(SUBSTITUTE(B$2:B$4,",",))+1>=COLUMN(A:I),ROW($2:$4),99),ROW(A1)))&""
G2:H9=IF($F2="","",TRIM(MID(SUBSTITUTE(VLOOKUP($F2,$A:$C,COLUMN(B1),),",",REPT(" ",99)),COUNTIF($F$2:$F2,$F2)*99-98,99)))
(2007版) I2:J9=IF($F2="","",","&G2&IF($F2=$F3,I3,""))
L2:L5{=INDEX(F:F,MIN(IF((COUNTIF(L$1:L1,F$2:F$9)=0)*(F$2:F$9<>""),ROW($2:$9),99)))&""
M2:N5=MID(VLOOKUP($L2,$F:$J,COLUMN(D1),),2,99)
留言
張貼留言