Excel find duplicates function

Excel Find Duplicates Function

Using the IF COUNTIF function in Excel can easily help us find duplicate data. As shown below:

Specific method:

Enter =IF(COUNTIF( A:A,A2)>1,"Repeat",""), then drag down.

What does the formula mean?

Look for the name in column A that is the same as the name in cell A2. If there are the same names, the countif function will count. When there are no duplicate names, the if judgment condition is not established and no input is required at this time. character. When a duplicate name appears, the if judgment is established and the word "duplicate" is output.

Of course, when we drag down (you should be able to do this, right? Select the cell, move the mouse to the edge of the lower right corner of the cell, wait until the mouse icon changes to a black cross, then click and hold When you hold it down and pull it down), A2 in the function will automatically change into A3, A4, and A5...

The method is very simple, but one function can solve a big trouble.

PHP Chinese website, a large number of excel basic tutorials and website construction tutorials are welcome to learn.

The above is the detailed content of Excel find duplicates function. For more information, please follow other related articles on the PHP Chinese website!