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

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

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

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

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

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

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

Thank you so much!

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

This was super helpful! Thank you!

Thanks man, I needed this !

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.

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.

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

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

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