Excelguru
268Posts
April 11, 2009Registration date
Apr 12, 2009 11:25am BST
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. To find FALSE search for FALSE