Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Show Duplicates in Excel?

Date:2022-7-17 Author:Sandra

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.

How to Show 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.

How to Show Duplicates in Excel?

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

How to Show Duplicates in Excel?

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

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *