How to quickly find duplicates with Excel functions

In fact, using Excel functions can easily help us solve this problem. The following figure:

How do I find duplicates quickly? Use the function formula bar.

In the B2 cell, enter =if (COUNTIF (A:A,A2) >1, Repeat, ""), and then drag down. What does the formula mean? In column A, look for names that have the same name as the A2 cell, and if you have the same name, the COUNTIF function counts, and if the duplicate name does not appear, if the judgment condition is not true, no characters are entered at this time. When duplicate names appear, the If judgment is established and the output is "duplicate".

Of course, when we drag down (this operation you should be?) Select the cell, move the mouse to the edge of the lower-right corner of the cell, until the mouse icon becomes a black cross, then the A2 in the function will automatically become A3, A4, A5 ...