Excel: How to find and count duplicate values in two listsby Ian HowlettMarch 3, 2016Use COUNTIF in Excel to quickly count how many values in one list appear in another.