拆分數值 (9015)

D2 下拉{=IFERROR(RIGHT(SMALL(IFERROR(TEXT(1000+(C$2:C$7="ST")*2000-TEXT(TEXT(((1+(C$2:C$7="ST")*2)*COLUMN(A:I))*1000-B$2:B$7,"[>"&1000+(C$2:C$7="ST")*2000&"]!0;0"),"0;!0;"&1000+(C$2:C$7="ST")*2000),"0;;")+(ROW($2:$7)*10+COLUMN(A:I))/1%%,""),ROW(A1)),4)*1,"")

另解 D2{=IFERROR(RIGHT(SMALL(IFERROR(TEXT(SUBSTITUTE(TEXT(TEXT(B$2:B$7-(1+(C$2:C$7="ST")*2)*(COLUMN(A:I)-1)*1000,"0;!0"),"[<="&1000+(C$2:C$7="ST")*2000&"]0;A"),"A",1000+(C$2:C$7="ST")*2000),"0;;")+(ROW($2:$7)*10+COLUMN(A:I))/1%%,""),ROW(A1)),4)*1,"")

F2 右拉 下拉{=TEXT(MIN(INDEX(TEXT($B2-(1000+($C2="ST")*2000)*(ROW($1:$9)-1),"0;!0")*1,COLUMN(A1)),1000+($C2="ST")*2000),"0;;")