What is the function formula to find duplicate values?

What is the function formula for finding duplicate values?

1. Open the excel table where duplicate values ​​need to be found, and find column A that needs to be found.

Recommended: "Excel Tutorial"

2. Position the mouse in cell C1 and enter the formula in the edit bar "=IF(COUNTIF($A:$A,A1)>1,"Repeat","Do Not Repeat")", press the Enter key on the keyboard, and cell C1 will display Not Repeated.

3. Place the mouse on the lower right corner of cell C1 and pull down. Duplicate cells will be displayed, and non-duplicated cells will be displayed as non-duplicate.

The above is the detailed content of What is the function formula to find duplicate values?. For more information, please follow other related articles on the PHP Chinese website!