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.


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.

4 responses to “How to Show Duplicates in Excel?”

  1. This actually answered my downside, thanks!

  2. I’m not that much of a online reader to be honest but your sites really nice, keep it up! I’ll go ahead and bookmark your website to come back down the road. Many thanks

  3. Well I really liked studying it. This subject provided by you is very constructive for correct planning.

Leave a Reply

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