Excel - Comparing two columns

September 2017

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.


Published by aakai1056. Latest update on February 22, 2012 at 09:09 AM by aakai1056.
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).