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)
- Find duplicates and compare two lists in Microsoft Excel by Chris Menard ( Download)
- Excel - Find & Highlight Duplicate Rows - 3 Methods | Conditional Formatting ( Download)
- Excel Conditional Formatting with the TODAY function | Duplicate Rule ( Download)
- Find Common Values From Two List In Excel @BrainUpp ( Download)
- Excel Conditional Formatting - Getting started with five examples ( Download)
- Excel Two-Way XLOOKUP - How to use XLOOKUP with two criteria in Excel | Nested XLOOKUP Tutorial ( Download)
- Create a PivotTable in Excel using multiple worksheets by Chris Menard ( Download)
- Find & Highlight Duplicate Rows | Find Duplicate Value Using CONDITIONAl FORMATTING ( Download)
- Excel - Copy and Move Data - Excel Essentials ( Download)
- Find Duplicates in Two Lists ( Download)
- Return Duplicates in Excel ( Download)
- Highlight duplicates in lists across worksheets ( Download)
- Conditional Formatting with Icon Sets in Excel ( Download)
- Use Conditional Formatting to compare two columns and highlight matches & filter by Chris Menard ( Download)
