材料/工具:Excel2010
1、以下图为例进行查找重复项的举例说明,如图所示。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/eaf81a4c510fd9f97703c00a2b2dd42a2834a4b9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、在查找重复项之前需要选中查找重复项目标区域,也可以直接选择整列,整列的选择直接点击列字母即可,多列的选择可按下shift并连续选择列字母即可实现。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0b7b02087bf40ad114915280592c11dfa9ecce58?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/c2cec3fdfc039245c9bf746c8994a4c27d1e254e?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/a8ec8a13632762d0898931dcaeec08fa513dc61a?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/a6efce1b9d16fdfa4ec2538dba8f8c5494ee7b23?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/a1ec08fa513d2697dd329d3e5bfbb2fb4216d8f4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
本回答被网友采纳