Excel - Comparing two columns

October 2016

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.

Related :

This document entitled « Excel - Comparing two columns » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.