第1个回答 2010-08-31
如果数据在A1:B100中,C1中输入
=INDEX(A$1:A$100,SMALL(IF(COUNTIF(B$1:B$100,A$1:A$100)=0,ROW($1:$100)),ROW(A1)))&""
同时按下CTRL+SHIFT+ENTER输入数组公式,D1中输入
=INDEX(B$1:B$100,SMALL(IF(COUNTIF(A$1:A$100,B$1:B$100)=0,ROW($1:$100)),ROW(A1)))&""
也是三键齐按输入数组公式,选中C1:D1,用自动填充柄向下复制公式.本回答被提问者采纳
第2个回答 2010-08-31
C1=IF(ISNUMBER(FIND(0,A1))*ISERR(FIND(0,B1)),0,)&SUBSTITUTE(SUMPRODUCT(ISNUMBER(FIND(ROW($1:$9),A1))*ISERR(FIND(ROW($1:$9),B1))*ROW($1:$9)*10^(9-ROW($1:$9))),0,)
D1=IF(ISNUMBER(FIND(0,B1))*ISERR(FIND(0,A1)),0,)&SUBSTITUTE(SUMPRODUCT(ISNUMBER(FIND(ROW($1:$9),B1))*ISERR(FIND(ROW($1:$9),A1))*ROW($1:$9)*10^(9-ROW($1:$9))),0,)
注:A列结果放在C列,B列结果放在D列