Sample files: Comparing values in Excel
These files demonstrate the techniques described in the articles How to use Excel’s conditional formatting to compare lists, How to use Excel formulas to compare multi-column lists, and How to use COUNTIFS() to compare multiple data sets.