Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1750.xlsx
Learn how to compare to lists and extract items in both lists, or exact the items that are not in both lists. Formula #1: Extract items in List 1 that are in List 2. Formula #2: Extract items in List 1 that are NOT in List 2.
1) (00:00) Intro
2) (00:30) Formula to extract items in both lists for versions of Excel other than Microsoft 365.
3) (00:40) Formula to extract items in both lists using XMATCH, ISNUMBER and FILTER.
4) (02:22) Formula to extract items NOT in both lists using XMATCH, ISNA and FILTER.
5) (02:44) Conclusion and video links

Link to video that shows 6 ways to compare two lists if you do not have Microsoft 365 Excel: https://www.youtube.com/watch?v=9h1omv60MCA

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

ExcelIsFunTue, August 24, 2021 7:47pm