202001211254排序 加一个数字等于15或者等于5 (6508)

C2:C22{=(0&MID(REPLACE(SUM(IFERROR(SMALL(RIGHT(SMALL(FIND(ROW($1:$10)-1,A2&1/17)/1%+MOD(6-ROW($1:$10),10),ROW(INDIRECT("1:"&COUNT(FIND(ROW($1:$10)-1,A2))))))*1,{1,2,3})*10^-{1,2,3},)),5,,REPT(0,1-ISERR(FIND(5,A2)))),3,9))*1

公式二{=--REPLACE(--RIGHT(SUM(IFERROR(LARGE(IF(1-ISERR(FIND(ROW($1:$10)-1,A2)),MOD(6-ROW($1:$10),10)),{1,2,3})*10^{0,1,2},10^4)),3),2-ISERR(FIND(5,A2)),,0)

公式三{=--REPLACE(SUM(LARGE(ISNUMBER(FIND(ROW($1:$10)-1,A2))*MOD(6-ROW($1:$10),10),{1,2,3})*10^{0,1,2}),2-ISERR(FIND(5,A2)),,0)

公式四{=REPLACE(SUBSTITUTE(SUM((1-ISERR(FIND(RIGHT(ROW(10:19)),A2)))*MOD(6-ROW(1:10),10)*10^RIGHT(ROW(4:13))),0,),2,,IF(ISERR(FIND(5,A2)),"",0))

公式五{=REPLACE(SUM(LARGE((MMULT(COLUMN(A:F)^0,0+(SMALL({5;15}-MID(A2,{1,2,3},1),ROW($1:$6))=COLUMN(A:I)))>0)*COLUMN(A:I),ROW($1:$3))*10^{0;1;2}),2,,IF(ISERR(FIND(5,A2)),,0))

公式六{=REPLACE(SUBSTITUTE(SUM((1-ISERR(FIND(MID(432109876,ROW($1:$9),1),A2)))*ROW($1:$9)*10^(9-ROW($1:$9))),0,),2,,IF(ISERR(FIND(5,A2)),,0))

公式七{=--REPLACE(SUM(LARGE(ISNUMBER(FIND(MOD(5-ROW($1:$9),10),A2))*ROW($1:$9),{1,2,3})*10^{0,1,2}),2-ISERR(FIND(5,A2)),,0)

公式八{=REPLACE(SUM(LARGE((1-ISERR(FIND(ROW($1:$10)-1,A2)))*MOD(6-ROW($1:$10),10),{3,2,1})*10^{2,1,0}),2,,IF(ISERR(FIND(5,A2)),"",0))

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank





Powered by Xuite