I2=SUMPRODUCT(MMULT(IFERROR(TRIM(MID(SUBSTITUTE(SUBSTITUTE(J2,"--","、"),"、",REPT(" ",99)),{1,2;3,4;5,6}*99-98,99))+{0,1},),{-1;1}))
B2=IF(ROW(A1)>SUM(I:I),"",OFFSET(H$1,LOOKUP(ROW(A1)-1,SUBTOTAL(9,OFFSET(I$1,,,ROW($1:$4))),ROW($1:$4)),))
C2=IF(B2="","",IF(B1<>B2,LEFT(VLOOKUP(B2,H:J,3,),6),IFERROR(MID(VLOOKUP(B2,H:J,3,),FIND("--"&C1,VLOOKUP(B2,H:J,3,))+9,6),0&C1+1)))
留言
張貼留言