Results 1 to 3 of 3
  1. #1
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    220
    Thanks
    13
    Thanked 0 Times in 0 Posts
    I have two Excel 2003 workbooks. Each has one field with a header row. Workbook 1 contains 160 unique records and Workbook 2 contains 140 unique records. The records all are of the general type. They are MD5 hash values. I want to know which records in Workbook 1 are not in Workbook 2. Is there a way to do this? Note that I can copy the records into one workbook, into two resepctive fields, if that would be easier. Thanks!
    JimmyW
    Helena, MT

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Let's say that the data are in column A in both sheets.
    Open both workbooks.
    In cell B2 on the first worksheet, start entering a formula:

    =ISERROR(MATCH(A2,

    Now switch to the second worksheet and select the data range, say A2:A141. You'll see something like

    =ISERROR(MATCH(A2,[OtherWorkbook.xls]Sheet1!$A$2:$A$141

    Finish the formula by adding ,0)) so that it looks like

    =ISERROR(MATCH(A2,[OtherWorkbook.xls]Sheet1!$A$2:$A$141,0))

    Confirm by clicking the green check mark.
    Fill down to the end of the data on the first sheet.
    Column B will display TRUE if the value in column A does not occur in the other sheet, FALSE otherwise.
    Close the second workbook before closing and saving the first one.

  3. #3
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    220
    Thanks
    13
    Thanked 0 Times in 0 Posts
    Thanks, Hans. I didn't receive a notice of a reply, so I did not visit the forum until today. I'm sorry for not getting back to you sooner! Your advice worked perfectly.
    JimmyW
    Helena, MT

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •