F5:P10{=IFERROR(RIGHT(0&SUM(MID($E5,MID(SMALL(IF((MMULT(N(MID(ROW($123:$345),{2,3},1)-MID(ROW($123:$345),{1,2},1)>0),{1;1})=2)*(MMULT(N(5-MID(ROW($123:$345),{1,2,3},1)>=0),{1;1;1})=3),ROW($123:$345)),COLUMN(A1)),{1,2,3},1),1)*10^{2,1,0}),3),"")
另解=IFERROR(MID($E5,MID("1111112223",COLUMN(A1),1),1)&MID($E5,MID("2223343344",COLUMN(A1),1),1)&MID($E5,MID("3454554555",COLUMN(A1),1),1),"")
另解{=IFERROR(TEXT(SUM(MID($E5,CHOOSE(COLUMN(A1),{1,2,3},{1,2,4},{1,2,5},{1,3,4},{1,3,5},{1,4,5},{2,3,4},{2,3,5},{2,4,5},{3,4,5}),1)*10^{2,1,0}),"000"),"")
留言
張貼留言