补充:a1-j1的十个数字中有重复的。
å
¬å¼å¯ä»¥åæå¦ä¸
=IF(COUNTIF(A1:J1,),,0)&SUBSTITUTE(SUM(IF(COUNTIF(A1:J1,ROW(1:9)),,ROW(1:9))*10^(9-ROW(1:9))),0,)
æ
=SUBSTITUTE(SUM(IF(COUNTIF(A1:J1,ROW(1:9)),,ROW(1:9))*10^ROW(1:9)),0,)&IF(COUNTIF(A1:J1,),,0)
æ°ç»å ¬å¼,æä¸SHIFT+CTRL+ENTERä¸é®ç»æè¾å ¥
=IF(COUNTIF(A1:J1,),,0)&SUBSTITUTE(SUM(IF(COUNTIF(A1:J1,ROW(1:9)),,ROW(1:9))*10^(9-ROW(1:9))),0,)
æ
=SUBSTITUTE(SUM(IF(COUNTIF(A1:J1,ROW(1:9)),,ROW(1:9))*10^ROW(1:9)),0,)&IF(COUNTIF(A1:J1,),,0)
æ°ç»å ¬å¼,æä¸SHIFT+CTRL+ENTERä¸é®ç»æè¾å ¥
温馨提示:答案为网友推荐,仅供参考
第1个回答 2013-04-01
用排序试试