Home >Common Problem >How to use ifcountif function to find duplicates in two columns
Use the ifcountif function to find two duplicate columns: first open the table file that needs to be filtered; then enter the formula "=countif (C:C, B:B)" in the blank box and press the Enter key; finally Press the shortcut key "ctrl shift L" to open the filter.
Recommended: "excel tutorial"
The countif function filters duplicate data. The advantage is that it can quickly filter huge data. At the same time, the two columns of data can correspond one-to-one through sorting, making it more accurate and convenient for inspection.
As shown in the figure, we now need to filter out the data in data A that is duplicated in data B. If we use conditional formatting to filter, the data in column A will be confused by the repeated data, so the data will be inaccurate.
So we use the function "countif". As shown in the figure, take another column "Filter". Enter "=countif (C:C,B:B)" in the blank box and press Enter. Here we need to pay attention to the order of selecting the sequence, because we want to filter out "data A", so we need to give priority to "data B", that is, "C:C" in the brackets comes first.
Then move the mouse to the lower right corner of the grid and double-click the left mouse button. This way the function will be copied automatically. as the picture shows.
Then move the mouse to the leftmost serial number "1" and quickly select the first row. Then press the shortcut key "ctrl shift L" to open filtering. as the picture shows.
Then click the "little triangle" in the filter column. As shown in the picture, check off option "0" and press the confirm key.
The last filtered out options are the duplicate options of "Data A" and "Data B". Here you will see that the number "2" is displayed because the "data B" of the corresponding row has two identical data. If there are three identical ones, "3" will be displayed.
The above is the detailed content of How to use ifcountif function to find duplicates in two columns. For more information, please follow other related articles on the PHP Chinese website!