D2=IFERROR(SUM(MID(B$2,MID(SMALL(IF({1;2;3}<>{1,2,3},{1;2;3}*10+{1,2,3}),ROW(A1)),{1,2},1),1)*{10,1}),"")
E2=IFERROR(SUM(MID(SUM(SMALL(MID(B$2,{1,2,3},1)*1,{1,2,3})*{100,10,1}),MID(SMALL(IF({1;2;3}<>{1,2,3},{1;2;3}*10+{1,2,3}),ROW(A1)),{1,2},1),1)*{10,1}),"")
另解 E2=IFERROR(SMALL(IF(MID(B$2,{1,2,3},1)-MID(B$2,{1;2;3},1),MID(B$2,{1,2,3},1)*10+MID(B$2,{1;2;3},1)),ROW(A1)),"")
留言
張貼留言