Finding duplicates with Conditional Formatting in Excel is easy when the data is on the same worksheet.
When the information is on two worksheets, you have to write a formula and use the CountIF function.
chrismenardtraining.com
And make sure you subscribe to my channel!
-- EQUIPMENT USED ---------------------------------
○ My camera – amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod – amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera – amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – chrismenardtraining.com/camtasia
○ Screenshots – Snagit – chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
- Excel - Conditional Formatting find duplicates on two worksheets by Chris Menard ( Download)
- How to compare two Excel files for duplicates ( Download)
- Compare Two Excel Worksheets & Find Duplicates Using Formula or Conditional Formatting ( Download)
- How to Compare Two Excel Sheets and Find Differences ( Download)
- Compare Two Sheets for Duplicates with Conditional Formatting ( Download)
- How to Compare Two Excel Sheets and Find Differences ( Download)
- How To Compare Excel Files and Find Differences ( Download)
- How Do You Merge Two Excel Files And Remove Duplicates ( Download)
- Easily compare two Excel lists for duplicates or unique values ( Download)
- How to Do a VLOOKUP With Two Spreadsheets in Excel ( Download)
- Google Sheets - Identify Duplicates between Two Worksheets ( Download)
- Match Names on Two Excel Sheets with VLOOKUP – Create Unique ID in Excel ( Download)
- How to Find Duplicates in Excel & Highlight Duplicates If You Need To ( Download)
- Excel Tricks: Compare Two Excel Files [Find the Differences] ( Download)
- MS Excel - Compare Two Sheets ( Download)
