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

Download the featured file here: www.bluepecantraining.com/wp-...
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

[@joanlopez18]

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

[@digitalzombie42]

This was super helpful! Thank you!

[@cheezeandcrackers]

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

[@taraacc4733]

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

[@SuperKransom]

Thank you so much!

[@jimmykhoury2001]

Thanks man, I needed this !

[@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.

[@lochadith6200]

Thank you Sir! 😍😍😍❤❤❤😘😘😘

[@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.

[@Jojosmith342]

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

[@kevinrogala5577]

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