How to Compare Two Columns in Excel 2007

By Jason Stewart

Microsoft Office Excel is one of the premier spreadsheet programs available for general use. Excel is easy to install and equally easy to get started on data analysis. Often, users will need to compare columns with one another to help find duplicate items or other data of interest. Luckily, comparing data is not a daunting task when you use a worksheet formula within Excel.

Things You'll Need

  • PC
  • Microsoft Office Excel

Step 1

Activate Excel and open a new worksheet. Set up three different columns entitled "A," "B" and "C". Allow for five data entries within each column so that you are working with a 3x5 grid.

Step 2

Enter the data for the two known columns in "A" and "C". Leave column "B" blank for the time being, and make sure not to enter zeros in the "B" column. Column "B" needs to remain blank because this is where the formula will be entered and function.

Step 3

Select the first cell in column "B" and enter the following formula therein; =IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1)

Step 4

Navigate to "Fill" from the "Edit" menu and click "Down". The duplicate data will appear in column "B." Rinse and repeat as needed with new data sets.

Tips & Warnings

  • The formula listed in the resource section is precoded for a 3x5 worksheet. Change the values in the formula to match the listings in your particular grouping.