Warning of duplicate values in Excel - Warning of data duplication
Microsoft Excel gives you lots of useful features to help your data entry work best. One of those features is the duplicate value warning feature.
For many important data that do not allow data to be duplicated, the use of duplicate value warning is essential. To know how to set up duplicate value alerts in Excel, you can follow the article below.
The article shows you how to warn duplicate values in Excel 2013, with Excel 2007 and 2010 you do the same.
Step 1: Select the data area to be alerted for duplicate values, next you select the Data tab on the Ribbon.
Warning of duplicate values in Excel - Warning of data duplication Picture 1
Step 2: In the Data Tools section, select Data Validation -> Data Validation .
Warning of duplicate values in Excel - Warning of data duplication Picture 2
Step 3: In the Settings tab, select Custom in Allow , and enter the formula in the Formula section . For example, if you want to warn duplicate values in C5: C11, then you enter the formula = COUNTIF ($ C $ 5: $ C $ 11, C5) = 1 .
Warning of duplicate values in Excel - Warning of data duplication Picture 3
Step 4: Select the Error Alert tab , here you select the type of alert in the Style section , enter the warning title in the Title section , enter the warning content in the Error message section . Then you click OK to finish.
Warning of duplicate values in Excel - Warning of data duplication Picture 4
So when you enter the duplicate content will receive a warning message of duplicate values.
Warning of duplicate values in Excel - Warning of data duplication Picture 5
Thus, with the function of warning of duplicate values of Data Validation in Excel, you can enter data quickly without worrying about data duplication. Good luck!
You should read it
- Find and delete duplicate data in Excel
- Filter duplicate data, delete duplicate data in Excel
- How to Find Duplicate Data in Excel
- To turn off Privacy Warning on Excel
- Filter data that doesn't overlap in Excel - Filter for unique values in Excel
- How to remove duplicates in excel
- How to create duplicate data entry notifications on Excel
- 2 ways to delete data, duplicate content in Excel
- How to filter duplicate data from 2 Sheets in Excel
- How to enable sensitive content warning on iPhone
- How to fix Service Battery battery warning on Mac: check charging cycle, calibrate battery of Mac
- Write a program to check duplicate values in Python
May be interested
Save, work and share files online in Excel 2013
Instructions to delete blank lines (blank lines) in Excel
Basic functions in Excel - Common calculator functions that you need to know in Excel
Some basic rules when editing Word documents
Common math functions in Excel
Common statistical functions in Excel