您现在的位置是：首页 > 办公软件 > excleexcle

EXCEL 避免重复录入数据

爱读书aread.cc2022-10-03 23:30:13excle0人已围观

简介.爱读书aread.cc翻译，转载请保留此信息 .
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 Cu

.爱读书aread.cc翻译，转载请保留此信息 .

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