excel批量查找sheet2表中数据在sheet1表中存在多少个重复值,sheet1表有10万数据,sheet2中有1000多数据,现想查出表2中所有数据在表1中重复出现的次数,应如何解决
æ¯å¦æ¥æ¾sheet2çAåä¸sheet1çAåéå¤é¡¹
Sheet2çB1è¾å ¥
=IF(COUNTIF(Sheet1!A:A,A1),"éå¤","")
å ¬å¼ä¸æ
éå¤é¡¹æ°é
=sumproduct(N(countif(sheet1!a:a,a1:a10)))