Find duplicates and compare two lists in Microsoft Excel by Chris Menard

Here's an Excel function to highlight duplicates. To compare two lists in Microsft Excel, to find duplicates, you can use either conditional formatting and write a formula or use COUNTIF function. I show both methods in this video.

CONDITIONAL FORMATTING
*******************************
Select A2 to A10
Conditional Formatting / New Rule
Click Formula to determine...
Type in the formula =countif($B:$B,$A2)
Click Format and pick a pattern
Click OK
***********************************
TYPING A FUNCTION
In C2 type =countif($A$2:$A$10,$B2) and autofill down.

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

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!

[xiaodongCa]

I watched twice. I used it and solved the problem I was stuck. Thank you. Thumbs up!

[jimmyobvious]

Very good explanation and right to the point. Thanks!

[roodyadelson]

Very good explanation, it's Crystal clear. Thanks a Lot!

[emmanuelabayie]

Bad teacher....u assume we know how to pull the formula