Compare Two Excel Worksheets & Find Duplicates Using Formula or Conditional Formatting

In this Microsoft Excel video tutorial I explain how to compare two worksheets and identify duplicates; I demonstrate two methods. The first method uses the COUNTIF function and the second method uses conditional formatting.

00:00 Introduction
00:44 Method 1 - Formula
03:21 Method 2 Conditional Formatting

[joanlopez]

This was the best version I've seen on how to do this! THANK YOU!!!

[cheezeandcrackers]

been looking all over for something like this! Finally found it. THANK YOU!

[rickdevous]

Great video!, You Take a couple of complicated formulas and ideas, and create an easy to follow result. Keep up the good work!

[jeansepulveda]

Thanks for the efficiency of the video. Simple and achieves the purpose!

[IvanCortinas_ES]

The final part that you mention about not having to use ">0" inside COUNT.IF seems very interesting to me. Thank you Chester.

[patriciabarbeau]

Thank you, your instructions were very clear and helpful. I really appreciate the tutorial.

[katiehardgrave]

Thank you so much! I've been looking for hours.

[ron]

Thank you, nice and simple achieving exactly what was required.

[taraacc]

Thank you Sir! Use me a lot and be successful.

[YeowooBBCVIP]

Took me 2hrs of fruitless research before ending up here, thanks!

[Juncti]

Outside of the main topic, I had no idea about some of the shortcuts used. F4 and double clicking that bottom right corner. I need a crash course on handy excel shortcuts as I'm clearly missing out.

[Jojosmith]

Hi Chester, I always thumbs up for your hard work and valuable tutorials. I have a large excel sheet with more than 10, 000 records which is a mixed data of Family and Singles. Ex: the family x9 people is considered as 1 job and a single individual is count as 1 also. Family x2 (Smith, Jessica & Smith, Bobby) = 1 or Family x6 people are still count as 1 task. Is there any way to create a formula to count and sum these tasks ? Thank you so much for your time and help.

[nagakshr]

Hi Chester
Is there a way where we can convert heading and paragrah in word to Excel where heading should be Row 1 and paragraph goes to Column 1. The same has to be applied for multiple headings and paragraphs

[karimmimoun]

Hello do you know how I can fix this problem How can I link two sheets so that I don't have a duplicate ID number when I create a new record with the user form? Thank you

[kevinrogala]

I cant get anything to work, i hate excel and want to die