打开要进行重复值检查的工作表,如下图所示:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d000baa1cd11728bec27b694c4fcc3cec3fd2c79?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
选择[数据]命令按钮,单击鼠标。[数据]命令位置如下图所示
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a71ea8d3fd1f41340e5c3fc8291f95cad1c85e18?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
点击该按钮就可以看到重复项的三个菜单:【高亮显示重复值】、【拒绝录入重复项】和【删除重复值】。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/55e736d12f2eb938f3064044d9628535e5dd6f18?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
选中将要进行重复值筛选的区域,如下图所示:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d000baa1cd11728bec68b694c4fcc3cec3fd2c3a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
按下图所示顺序点击鼠标后,会弹出一个对话窗口,如下图二所示:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b58f8c5494eef01f401e2273ecfe9925bc317d79?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d788d43f8794a4c2cb66dd9d02f41bd5ad6e393a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
图中对话窗口的=$B$1:$D$19表示的意思是:B列第一行至D列第19行为我们选中的区域
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9345d688d43f879411ba7298de1b0ef41bd53a3a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
单击确定后,重复的项就会用颜色标记显示,如下图所示:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f2deb48f8c5494ee894435af21f5e0fe99257e25?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
8
重复项中的【拒绝录入重复项】和【删除重复值】在这就不再详细讲述了,大家可以