Excel - Comparing two columns

April 2018

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 (https://ccm.net/).
VBA code not working
Excel - A macro to create new workbook and copy data