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!

4.3 ★ | 3 Vote

May be interested

  • Limit input values ​​using Data Validation in ExcelLimit input values ​​using Data Validation in Excel
    to avoid data confusion, you should set a limit for the column of data cells to minimize the consequences of confusion. the following article will guide you in detail how to limit the value entered by data validation in excel.
  • Top 3 software to find the best duplicate filesTop 3 software to find the best duplicate files
    top 3 software to find the best duplicate files. file duplication is one of the evils that make your computer heavy and space consuming. it will be very difficult to solve if you search each file, time consuming and also very laborious.
  • How to convert a CSV file to ExcelHow to convert a CSV file to Excel
    how to convert a csv file to excel. csv stands for comma separated values, which is a simple text format where values ​​are separated by commas. both csv and excel are files that help store data in spreadsheets. however, csv also has advantages and disadvantages compared to excel software. t
  • How to limit the value entered by Data Validation ExcelHow to limit the value entered by Data Validation Excel
    data validation on excel is a feature that will help users create data entry limits on excel. when entering that limit number you will receive a notification.
  • How to filter duplicate data on 2 Excel sheetsHow to filter duplicate data on 2 Excel sheets
    to filter duplicate data from 2 sheets in excel, you can use the vlookup function.
  • How to compare data on 2 Excel columnsHow to compare data on 2 Excel columns
    users can compare data on 2 excel columns with the countif function.
  • Write a program to find duplicate values ​​in PythonWrite a program to find duplicate values ​​in Python
    if you want to learn how to write a program to find duplicate values ​​in python, this is the article for you.
  • To turn off Privacy Warning on ExcelTo turn off Privacy Warning on Excel
    when you open an excel file with a macros, it usually comes with a privacy warning message. so how to turn off privacy warning notification in excel?
  • 10 effective SEO content checking tools10 effective SEO content checking tools
    duplicating content while doing seo is not a rare thing. you can duplicate images, videos, especially article content many times on the same website or in many different websites. therefore, to check if the content is neutral or not, use up to 10 free testing tools ...
  • How to copy values ​​in ExcelHow to copy values ​​in Excel
    how to copy values ​​in excel. in excel, if we use the usual copy-paste method (ctrl + c - ctrl + v), you will copy the entire contents of that cell including the function.