In this article we will learn about how to prevent duplicates while entering the data in Microsoft Excel 2010. We can use Countif formula to prevent the duplicates entry.
COUNTIF: – By using this formula you can identify the duplicate entries in a data and can capture duplicate entries in a range.
Syntax of “COUNTIF” function: =COUNTIF (range,criteria)
We have table in range A2:A11, in which needs to count of states that how many times states are repeating in Column A.
Let’s take an example to understand how and where we can prevent the duplicate entries.
We have a data of Mobile nos. In which we want to stop the duplicate entries of mobile numbers.
To preventing duplicates while entering in the data follow below given steps:-
This is the way you can restrict the duplicate entries in a data by using the Data Validation option in Microsoft Excel 2010 and 2013.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.