您现在的位置是:首页 > 办公软件 > 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.
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.
Tags:
很赞哦! ()
相关文章
随机图文
-
EXCEL 求选定区域内不重复数据的个数
.爱读书aread.cc翻译,转载请保留此信息 . Counting number of unique entries in a specified range. By using SUMPRODUCT along with COUNT to count only the number of unique entries in a specified range. T -
excel2010条件格式_excel多条件判断
Excel-条件格式 excel中的“条件格式”是一个被我们忽略的神器按钮,它可以帮助我们在实 -
EXCEL 为不同的人设定编辑权限
爱读书aread.cc原创,转载请保留此信息 . 如果一张excel工作表需要多人编辑,每个人只能编辑、修改指定范围,表的管理员需要进行如下操作: -
EXCEL 打印时忽略图片、图表等对象的方法
爱读书aread.cc翻译,转载请保留此信息 . To prevent objects from being printed: Technique 1:方法一 1. From the File menu, select Page Setup. 2. Select the Sheet tab. 3. In Print, select the Draft quality
留言与评论 (共有 条评论) |