1、两列数据中找出唯一不重复的数据
首先打开Excel表格,然后选中AB两列数据。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/574e9258d109b3de46236c01c3bf6c81800a4c3f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、然后选中条件格式--突出显示单元格规则--重复值。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/eac4b74543a98226fc3aa34e8582b9014b90ebe4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、然后再次选择“唯一”选项,后面的 颜色可以不用选择,也可以自行选择。这样数据就出来了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/562c11dfa9ec8a133dfcdf89f803918fa1ecc0f1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、完成效果图。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/80cb39dbb6fd5266c0cab47da418972bd50736f1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、A/B列对比,A列中的数据B列没有的
首先打开Excel表格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3801213fb80e7bece73b8b88202eb9389a506bf2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、然后在C1单元格输入公式“=IF(COUNTIF(B:B,A1)>0,"B列有","B列没有")”,按下回车。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a8773912b31bb051c6b23b41397adab44bede0c1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、然后将鼠标放在C1单元格右下角,待出现“+”后,双击或者直接拖下来填充数据即可。这样2列不同的数据就会有显示出来的。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/bba1cd11728b471042cf75a5cccec3fdfd0323f3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)