excel表格,两个数组中,并返回重复数字的个数答:C1 =SUMPRODUCT(COUNTIF(A1:A5,B1:B5))D1 =IF(ROW()>SUMPRODUCT(COUNTIF(A$1:A$5,B$1:B$5)),"",INDEX(A:A,SMALL(IF(COUNTIF(B:B,A$1:A$5),ROW($1:$5),4^8),ROW(1:1)))数组公式i以ctrl+shift+enter三键组合结束输入 下拉5行 E1 =IF(D1="","","A"&MATCH(D1,A...