Skip to Content
Communication Square LLC Help Center

Compare 2 columns in excel

Compare 2 columns in excel

Written September 2022. Microsoft changes these admin screens often, so the screenshots below may not match what you see today. The sequence of steps is usually still correct — if something looks wrong, tell us and we'll update it.

1.

2.

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”)

Last updated on

Related articles