EXCEL 避免重复录入数据

由 卓别林 创建, 最后一次修改 2015-11-04

.中国教程网zhangditony翻译,转载请保留此信息 .

 

1. Select a range of cells, for example, E2:E10.
2. From the Data menu, select Validation.
3. Select the Settings tab.
4. From the Allow dropdown list, select Custom.
5. In the Formula box, enter the following formula:
=COUNTIF($E$2:$E$10,E2)=1
6. Select the Error Alert tab.
7. In the Error message box, enter "The value you entered already appears in the list above".
8. Click OK.

避免重复录入.gif

以上内容是否对您有帮助:

二维码
建议反馈
二维码