MS Excel - Prevent Duplicate Entry in certain column
1.Select the range of cells in which you want to prevent duplicates (for example, A1:A50).
2.From the Data menu select Validation.
3.Click on the Settings tab.
4.From the Allow dropdown box select Custom.
5.In the formula box type =COUNTIF($A$1:$A$50,A1)=1
6.Click on the Error Alert tab.
7.In the Title box type "Duplicate Entry!"
8.In the Error Message box type "NO duplicate"
1.Select the range of cells in which you want to prevent duplicates (for example, A1:A50).
2.From the Data menu select Validation.
3.Click on the Settings tab.
4.From the Allow dropdown box select Custom.
5.In the formula box type =COUNTIF($A$1:$A$50,A1)=1
6.Click on the Error Alert tab.
7.In the Title box type "Duplicate Entry!"
8.In the Error Message box type "NO duplicate"
No comments:
Post a Comment