輔助 2改 {=SUM(SMALL(MMULT(N(ROW($1:$5)-LEN(SUBSTITUTE(LEFT(B$1,ROW($1:$5)),MID(B$1,ROW($1:$5),1),))+MID(B$1,ROW($1:$5),1)*10={1,2,3,4,5}-LEN(SUBSTITUTE(LEFT($A2,{1,2,3,4,5}),MID($A2,{1,2,3,4,5},1),))+MID($A2,{1,2,3,4,5},1)*10),{1;2;3;4;5}),ROW($1:$5))*10^{4;3;2;1;0})
跳過輔助 1 直接用 輔助 2{=IF(OR(LEN(B18)={3,4}),LEFT(SUM((0&MID(B$1,MID(B18&9&9,ROW($1:$5),1),1))*10^{4;3;2;1;0}),LEN(B18)),"")
|