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

[@ron200388]

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

[@joanlopez18]

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

[@patriciabarbeau6069]

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

[@cheezeandcrackers]

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

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

[@taraacc4733]

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

[@katiehardgrave4495]

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

[@SuperKransom]

Thank you so much!

[@lochadith6200]

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

[@jimmykhoury2001]

Thanks man, I needed this !

[@digitalzombie42]

This was super helpful! Thank you!

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

[@karimmimoun2482]

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

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