Articles on: Excel

Compare 2 columns in excel

Compare 2 columns in excel







Conditional formatting Select both column

                Conditional formatting, highlight duplicate with color

                Conditional formatting, highlight unique with different color

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



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

Updated on: 31/01/2023

Was this article helpful?

Share your feedback

Cancel

Thank you!