方法如下:
操作设备:戴尔电脑
操作系统:win10
操作软件:excel
1、首先在excel表格中输入两组需要比对的数据,该两组数据中有重复数据需要挑选出来。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d01373f082025aafac029d5be9edab64034f1a69?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、然后在C1单元格中输入函数公式:=IF(COUNTIF(A:A,B1),"重复",""),意思是用B1的数据在A列中查找是否重复。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/83025aafa40f4bfbf1e07dc4114f78f0f7361869?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、点击回车可以看到比对的B1单元格在A列中有重复数据,所以在C1单元格中显示了“重复”字样。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/72f082025aafa40f42f62d4db964034f78f01969?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、最后将单元格中的公式向下填充即可看到B列中在A列中有重复的数据的单元格中会被标注出字样,将这些单元格挑出即可。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d043ad4bd11373f0840f8c0fb60f4bfbfbed0469?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)