Browse » Home
Friday, July 27, 2012
How to Compare Two Columns in Excel 2007
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.
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.
3. Select the first cell in column 'B' and enter the following formula therein; =IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),'',A1)
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.