B2 右拉 下拉{=IFERROR(RIGHT(0&SUM(MID(B$1,MID(SMALL(IF((MMULT(N(MID(ROW(INDIRECT("123:"&MID(123456789,LEN(B$1)-2,3))),{2,3},1)-MID(ROW(INDIRECT("123:"&MID(123456789,LEN(B$1)-2,3))),{1,2},1)>0),{1;1})=2)*(MMULT(N(LEN(B$1)-MID(ROW(INDIRECT("123:"&MID(123456789,LEN(B$1)-2,3))),{1,2,3},1)>=0),{1;1;1})=3),ROW(INDIRECT("123:"&MID(123456789,LEN(B$1)-2,3)))),ROW(A1)),{1,2,3},1),1)*10^{2,1,0}),3),"")
留言
張貼留言