Compare 2 columns in excel

3. Conditional formatting Select both column

Conditional formatting, highlight duplicate with color

Conditional formatting, highlight unique with different color

4. =Vlookup(A2, select range and lock,1,0)

5. =iferror(vlookup(a1, b1:b35,1,0), “not found”)

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Last updated on October 11, 2022