<p>用“&”可以改短此:</p><p>(普通公式)=MID($A1&$B1&$C1&"0123456789",SMALL(FIND({0,1,2,3,4,5,6,7,8,9},$A1&$B1&$C1&"0123456789"),COLUMN(A1)),1)</p><p>(数组)=MID($A1&$B1&$C1&"0123456789",SMALL(FIND(ROW($1:$10)-1,$A1&$B1&$C1&"0123456789"),COLUMN(A1)),1)</p> |