前后2个数字相减 (11416)

E3{=SUM(RIGHT(SMALL(IFERROR(MID(D3,SMALL(IF(ISNUMBER(-MID(D3,ROW($1:98),1))*ISERR(-MID(D3,ROW($2:99),1)),ROW($1:98)),{1,2})-ROW($1:$9)+1,ROW($1:$9))*1,)+{1,2}*10^9,{1,2}*9),9)*{-1,1})



留言