Technology Software

How to Compare Cells in Excel

    • 1). Enter or import the first set of data into column A on the Excel spreadsheet.

    • 2). Enter or import the second column of data into Column C of the same spreadsheet.

    • 3). Leave Column B empty.

    • 4). Type the following formula in cell B1:
      =IF(ISERROR(MATCH(A1,$C$1:$C$#,0)),"",A1)
      where # is the row number of the last value in column C.

    • 5). Select cells in column B, starting at B1, and continuing down to the row number corresponding to the last row in columns A and/or B.

    • 6). Go to the Edit menu and click on "Fill", and then "Down", and you are finished comparing the cells. Column B will fill with the duplicate numbers in columns A and C.

Leave a reply