Compare lists in Excel: 6 ways to find differences
We often need to compare lists in Excel, and find out which items are in one but not the other. In this video, I show 6 methods for doing that including conditional formatting, data validation, Power Query and 3 formula methods =UNIQUE(VSTACK()), =COUNTIFS and =VLOOKUP.
To download example workbooks, enter email here: https://www.xlconsulting-asia.com/soc...
To fix corrupt Excel files, explore this tool: https://www.stellarinfo.com/repair-ex...
For more on approximate matching, see this video: • Fuzzy matching in Power Query in Excel & P...
00:00 Introduction
00:31 Highlight them
01:26 Big red dircle
02:25 COUNTIFS
03:37 VLOOKUP
03:59 UNIQUE and VSTACK
05:58 Power Query anti join