Forum Discussion
Niraj1
Jul 27, 2023Copper Contributor
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.
SergeiBaklan
Jul 27, 2023MVP
That could be with formula for conditional formatting rule as
=(C3<>"")*(COUNTIF($B$3:$B$11, C3)=0)