excel 找两单元格相同的数字

显示全部楼层 · 2009-6-9 10:45:14

在C1输入公式：=IF(COUNT(FIND(0,A1)*FIND(0,B1)),0,"")&SUBSTITUTE(SUM(ISNUMBER(FIND(ROW(1:9),A1)*FIND(ROW(1:9),B1))*ROW(1:9)*10^(9-ROW(1:9))),0,"")数组公式，公式在编辑状态下按Ctrl+Shift+Enter确定。...

千问 · 2009-6-9 10:45:14

C1输入:=IF(LEN($A$1&$B$1)-SUM(IF(ISERROR(FIND(ROW($1:$10),$A$1&$B$1)),0,1))<COLUMN(C1)-2,"",SMALL(IF((IF(ISERROR(FIND(ROW($1:$10)-1,$A$1)),0,1))*(IF(ISERROR(FIND(ROW($1:$10)-1,$B$1...