Search for answers to your questions by entering keywords below, or look through our knowledge base.
Welcome to 'Sikkhon' User Forum
Thanks for visiting our Forum. It provides an opportunity for our visitors/users to interact with out team and fellow visitors/users.
You can find further resources in Knowledge Base and tutorials. Please don't submit any personal or confidential info here, instead create a ticket.
To prevent duplicate values in excel i am using data validation and COUNTIF function. =COUNTIF(D30:D37,D30:D37). But, After entering that code my code is not working. still accepted the duplicate values. please take a look the below screenshot.
Here is the data validation code sample
Let's start to solve that issue:
Fisrt of all your formula is wrong here. simply edit the data validation formula :
=COUNTIF(E:E,E:E)
Or Change it to =COUNTIF($E$30:$E$40,E30)=1
After change the code you will get like below
As you can see, this function counts the number of values in the range E30:E40 that are equal to the value in cell E30. Again, this value may only occur once (=1) since we don't want duplicate entries. Absolute values are required here because you want to compare the top of the list to the data that appears below it.
To prevent duplicate values in excel i am using data validation and COUNTIF function. =COUNTIF(D30:D37,D30:D37). But, After entering that code my code is not working. still accepted the duplicate values. please take a look the below screenshot.
Here is the data validation code sample
Let's start to solve that issue:
Fisrt of all your formula is wrong here. simply edit the data validation formula :
=COUNTIF(E:E,E:E)
Or Change it to =COUNTIF($E$30:$E$40,E30)=1
After change the code you will get like below
As you can see, this function counts the number of values in the range E30:E40 that are equal to the value in cell E30. Again, this value may only occur once (=1) since we don't want duplicate entries. Absolute values are required here because you want to compare the top of the list to the data that appears below it.
#sikkhon #msexcel
0 Votes
0 Comments
Login or Sign up to post a comment