I3:I20{=INDEX(A:A,SMALL(IF(LEN(B$3:B$4)-LEN(SUBSTITUTE(B$3:B$4,",",))+1>=COLUMN(A:Z),{3;4},9),ROW(A1)))&""
J3:J20=IF(I3="","",MID(TRIM(MID(SUBSTITUTE(SUBSTITUTE(VLOOKUP(I3,A:B,2,),"""",),",",REPT(" ",99)),COUNTIF(I$3:I3,I3)*99-98,99)),2+(COUNTIF(I$3:I3,I3)=1),4))
留言
張貼留言