Excel - Comparing two columns

Here's a simple formula allowing you to compare 2 columns:

  • In a new column, put =cell1=cell2 and drag this to the end
  • Eg Two compare column1 & column2, in cell(A3) put '=A1=A2' If both the values are same, TRUE will be displayed.
Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled « Excel - Comparing two columns », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).