Compare 2 columns in excel

Articles on: 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

Updated on: 01/07/2024