How to Compare Two Columns in Excel 2007

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.

...
Compare data in two columns with Excel

Step

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

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

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

Step

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.