Forum Discussion

Copper Contributor

Jul 27, 2023

Excel Compare two columns to find unmatched values

I want to compare two columns (A and B) and want to identify the values in B which are not present in A.

Silver Contributor

Sep 10, 2024

If there are no extras in ListOne or duplicates in ListTwo

= UNIQUE(VSTACK(ListOne, ListTwo), , TRUE)

would do.

If there are values in ListOne that do not occur in ListTwo they may be eliminated by using

= UNIQUE(VSTACK(ListOne, ListOne, UNIQUE(ListTwo)), , TRUE)

would give the result required.