找出两列数据重复的项


Warning: Undefined array key "HTTP_REFERER" in /www/wwwroot/prod/www.enjoyasp.net/wp-content/plugins/google-highlight/google-hilite.php on line 58

放到excel中,利用countif函数求解 如:=COUNTIF($A$2:$A$65535,B2),得出重复的数量,然后筛选出数量大于0的即可。