Excel How-to
Compare Two Columns in Excel and Google Sheets and Find Missing Values
Find values in column A missing from column B with COUNTIF, FILTER, MATCH, and XLOOKUP. Trailing spaces and case are covered; tested in Google Sheets.
1 tutorial tagged “match”.
Find values in column A missing from column B with COUNTIF, FILTER, MATCH, and XLOOKUP. Trailing spaces and case are covered; tested in Google Sheets.