C2{=MIN(IF(RIGHT(ROW(INDIRECT(LEFT(1234,ROW(A2))&":"&LEFT(9876,ROW(A2))))*4,ROW(A2))-MMULT(MID(ROW(INDIRECT(LEFT(1234,ROW(A2))&":"&LEFT(9876,ROW(A2)))),TRANSPOSE(ROW(INDIRECT("1:"&ROW(A2)))),1)*1,10^(ROW(INDIRECT("1:"&ROW(A2)))-1))=0,ROW(INDIRECT(LEFT(1234,ROW(A2))&":"&LEFT(9876,ROW(A2))))))
4位數結果=SUMPRODUCT((ROW(INDIRECT(1234&":"&2300))*4=MMULT(MID(ROW(INDIRECT(1234&":"&2300)),{1,2,3,4},1)*1,{1;10;100;1000}))*ROW(INDIRECT(1234&":"&2300)))
4位數結果{=MATCH(1=1,ROW(INDIRECT(1234&":"&2300))*4=MMULT(MID(ROW(INDIRECT(1234&":"&2300)),{1,2,3,4},1)*1,{1;10;100;1000}),)+1233
留言
張貼留言