E2{=SUBSTITUTE(OFFSET(A$1,SMALL(IF(LEN(B$2:B$6)-LEN(SUBSTITUTE(B$2:B$6,",",))+1>=COLUMN(A:H),ROW($1:$5),99),ROW(A1)),)&"",LOOKUP(1,0/(E$1:E1<>""),E$1:E1),)
F2=TRIM(MID(SUBSTITUTE(VLOOKUP(LOOKUP(1,0/(E$2:E2<>""),E$2:E2),A:C,2,),",",REPT(" ",99)),(1+ROW(A1)-LOOKUP(1,0/(E$2:E2<>""),ROW($1:1)))*99-98,99))
G2=IF(F2="","",VLOOKUP(LOOKUP(1,0/(E$2:E2<>""),E$2:E2),A:C,3,))
留言
張貼留言