免费AI编程助手
EXCEL 避免重复录入数据
2018-09-23 13:57 更新
.中国教程网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.
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.
以上内容是否对您有帮助：
更多建议：