E2{=INDEX(A:A,SMALL(IF((LEN(B$2:B$3)-LEN(SUBSTITUTE(B$2:B$3,"/",))+1)*(LEN(C$2:C$3)-LEN(SUBSTITUTE(C$2:C$3,",",))+1)>=COLUMN(A:Z),{2;3},99),ROW(A1)))&""
F2{=IFERROR(TRIM(MID(SUBSTITUTE(VLOOKUP(E2,A:B,2,),"/",REPT(" ",99)),(INT((COUNTIF(E$2:E2,E2)-1)/(SUM(N(MID(VLOOKUP(E2,A:C,3,),ROW($1:$99),1)=","))+1))+1)*99-98,99)),"")
G2{=IFERROR(TRIM(MID(SUBSTITUTE(VLOOKUP(E2,A:C,3,),",",REPT(" ",99)),(MOD(COUNTIF(E$2:E2,E2)-1,SUM(N(MID(VLOOKUP(E2,A:C,3,),ROW($1:$99),1)=","))+1)+1)*99-98,99)),"")
留言
張貼留言