How to avoid duplication checking of data in tables

Method: First select the specified cell, click "Data" - "Data Validation" - at the top of the page; then select the "Settings" tab in the new window that pops up; then select the "Allow" drop-down list Select "Custom"; finally enter "=countif (data range, cell)=1" in the "Formula" drop-down list.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2016 version, Dell G3 computer.

The following takes Excel2016 as an example to open the Excel form that needs to input data information.

You can click the left mouse button to select the cells that need to be set to avoid data duplication, or you can move the cursor over a column and click to select all, then click [Data] in the option bar and select [ Select [Data Validation] from the drop-down menu.

Start setting up in the pop-up [Data Verification] window, select the [Custom] option, and enter the formula [=countif(a:a,a1)=1] Just click OK. Function explanation: The "COUNTIF function" indicates that the number of cells matching A1 in the statistical area of ​​column A is 1.

If you enter any repeated value in the set cell, a warning window will pop up.

Related learning recommendations: excel tutorial

The above is the detailed content of How to avoid duplication checking of data in tables. For more information, please follow other related articles on the PHP Chinese website!