操作设备:戴尔电脑
操作系统:win10
操作软件:EXCEL2017
1、首先打开一个内有数据的表格,如下图所示:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0dd7912397dda144b95a11d3a2b7d0a20cf4867b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、选中F3单元格,在单元格中输入“=”,如下图所示:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9213b07eca8065381cb9d97287dda144ad34827b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、弹出【插入函数】对话框,然后在“选择函数”中选择“IF”函数,然后点击【确定】按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b17eca8065380cd7804ddf8cb144ad345982817b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、将光标移动到第一个参数后面的对话框中输入“COUNTIF(B3:B12,E3)>0”;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/902397dda144ad344cecfae6c0a20cf431ad857b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、将光标移动到第二个参数后面输入“相同”,如下图所示:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/64380cd7912397ddb22ae5654982b2b7d0a2877b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、将光标移动到第三个参数后面输入“不同”,所有参数设置好后点击【确定】按钮,如下图所示:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b3119313b07eca806a564486812397dda144837b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、返回到工作表中即可进行两列数据的核对,如下图所示:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/cb8065380cd7912385b3e915bd345982b2b7807b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
本回答被网友采纳