|
C1输入数组公式:- =RIGHT(0&SUBSTITUTE(SUM(IF(ISERR(FIND(ROW($1:$10)-1,A1&B1)),ROW($1:$10)-1)*10^(10-ROW($1:$10))),0,),10-COUNT(FIND(ROW($1:$10)-1,A1&B1)))
复制代码- =IF(ISNUMBER(FIND(0,A1&B1)),"",0)&SUBSTITUTE(SUM(IF(ISERR(FIND(ROW($1:$9),A1&B1)),ROW($1:$9))*10^(9-ROW($1:$9))),0,)
复制代码 |
|