Compare Two Lists and Find Matches and Differences using the Excel COMPARE function

Compare Two Lists and Find Matches and Differences using the Excel COMPARE function

In this video, I'll show you how to compare two lists in Excel to find and extract matches and differences. We provide a powerful function that is compatible with ALL Excel versions. You can use a single formula that uses the COMPARE function to find the matches and differences in two lists. Using built-in functions like MATCH, ISNUMBER, and ISNA is not necessary.

Download DataFX free Excel function library:

Chapters:

0:00 Intro
0:25 How to Compare Two Lists and Find Matches and Differences
0:55 Find records in range 1 which do not exist in range 2
1:25 Find records in range 2 which do not exist in range 1
1:48 Compare two lists using DataXL free add-in
2:24 Thank you

#msexcel #excel #exceltips #exceltricks #excelformula #excelfunctions #productivity #datacleaning #datacleansing

[MichaelBrown-lwkz]

This explanation is perfect. It is brief and to the point.

[U-Tuber.]

looks like the COMPARE function is not yet added to Microsoft 365, Isn't it?
Nevertheless, Thanks for the vid; it hits its purpose with a very easy and comprehensible explanation

[rajeevgosavi]

Sir, please explain in details . Do we have to download datafx to get this compare function, as I don't have this function in my Office 365 yet.

[TsuDenom]

Thank you Sir - but how do we ADD this function as many (comments below) do NOT have the function🙏

[maurisasommerfield]

I'm having trouble finding this add-in in Microsoft 365 . Is this separate code to drop in to create a user defined function? How do I know it's not adding malware?

[michelejacobs]

I can't get this to work with numbers and I believe it may be of the formatting. I have a 12 digit number with leading zero formatted as custom.