查看: 610|回复: 4

microsoft

[复制链接]

zaik940

2017-4-18 04:03 PM

请问各位电脑大神，microsoft 的软件，有没有打了一样的log no,他会出提示通知你这个号码repeat了？

zaik940

2017-4-18 07:50 PM

upupup，有没有大神知道有这种软件

ranth

2017-4-18 08:08 PM

什么log no？

ICE_EvIL

2017-4-19 08:28 AM

Alert checking 需要macro create一个Data validation的button，

Select the range of cells in which you want to prevent duplicates (for example, A1:A50).
From the Data menu select Validation.
Click on the Settings tab.
From the Allow dropdown box select Custom.
In the formula box type =COUNTIF($A$1

A$50,A1)=1
Click on the Error Alert tab.
In the Title box type "Duplicate Entry!"
In the Error Message box type "You cannot enter a value already in the list."

如果你只是要确保不要duplicate，在Data -> Data Tools-> Remove Duplicates是最简单的

zaik940

2017-4-19 09:09 AM

ICE_EvIL 发表于 2017-4-19 08:28 AM
Alert checking 需要macro create一个Data validation的button，

Select the range of cells in which y ...

谢谢，弄到了！！感恩

返回列表

microsoft

浏览过的版块