F2:G2=INDEX(MMULT(MID(SUBSTITUTE(SUBSTITUTE($A2:$D2,"）",),"（",REPT(" ",99)),{1;99},99)*1,{1;1;1;1}),COLUMN(A1))
F2=SUMPRODUCT(--LEFT(A2:D2,FIND("（",A2:D2)-1))
G2=SUMPRODUCT(-MID(A2:D2,FIND("（",A2:D2),9))
區域數組{=TRANSPOSE(MMULT(IMREAL(IMDIV(SUBSTITUTE(SUBSTITUTE($A2:$D2,"（","+"),"）","j"),{1;"j"})),{1;1;1;1}))
F2:G2{=SUM(TEXT(CHAR(43+(COLUMN(A1)-1)*2)&1%,SUBSTITUTE(LEFT($A2:$D2,LEN($A2:$D2)-1),"（",";"))*1)
區域數組{=TRANSPOSE(MMULT(ABS(TEXT({1;-1}%,SUBSTITUTE(A2:D2,"（",";（"))),{1;1;1;1}))
留言
張貼留言