How can I compare two columns to see which cells are different? Thanks. Excel 2003 SP3
V VMI Aug 27, 2008 #1 How can I compare two columns to see which cells are different? Thanks. Excel 2003 SP3
A Ak Man Aug 27, 2008 #2 If you want to compare contents of column B with A, use this formula in column C =IF(COUNTIF(A:A,B1)>0,"Match","No Match")
If you want to compare contents of column B with A, use this formula in column C =IF(COUNTIF(A:A,B1)>0,"Match","No Match")
