Sometimes we want to count the times of repeated data in Excel.  So, we need to show duplicates in Excel, and quickly find duplicates in Excel, not remove them. Do you know how to quickly show duplicates in Excel?

Let’s take an example. Here is a list of names in column A.

We can use a formula to find duplicates in Excel.

Enter this formula in cell B2 and press Enter key.

=IF(COUNTIF(A:A,A2)>1,”Repeat”,””)

You can just copy and past this.

Then we use the fill handle to show all the duplicates.

That’s the way to find duplicate cells in Excel.