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