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.