Compare Two Columns of Data in Excel

You have two long columns of similar data and you want to find differences, if any. Assuming the columns are A and B, in cell C1 enter this formula


and copy it down column C as far as the data goes. Click Calculate in the Formulas tab and column C will display all the items that appear in column A but not column B.

Add Background to a Single Page (Word)
Image Add-ins