microsoft

zaik940

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

zaik940

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

ranth

什么log no？

ICE_EvIL

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$1A$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

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

Select the range of cells in which y ...

谢谢，弄到了！！感恩