Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
MS Excel 2000 - Compare two lists of data.
I have two different files, both use the same unique identifiers. How can I
ascertain which records are missing from the smaller file. For example: File A, has 28,225 different records. File B, has 14,205 different records. Which records from File A, are missing from File B? Thank you, Jerry |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
MS Excel 2000 - Compare two lists of data.
Hi,
if you apply a vlookup then everything that shows as #N/A means that are missing from the other list Let' say your File A is in sheet1 and File B in sheet2 starting in cell A2, in B2 sheet1 enter =VLOOKUP(A2,Sheet2!A1:A25000,1,FALSE) "Jerry" wrote: I have two different files, both use the same unique identifiers. How can I ascertain which records are missing from the smaller file. For example: File A, has 28,225 different records. File B, has 14,205 different records. Which records from File A, are missing from File B? Thank you, Jerry |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
MS Excel 2000 - Compare two lists of data.
Eduardo, than you for your quick reply. I would have responded sooner I have
been having a hard time trying to make your solution work, and was unsuccessful -all, came back "#N/A". I must be doing something wrong. Could you please elaborate, I am not an Excel power user. Thanks. "Eduardo" wrote: Hi, if you apply a vlookup then everything that shows as #N/A means that are missing from the other list Let' say your File A is in sheet1 and File B in sheet2 starting in cell A2, in B2 sheet1 enter =VLOOKUP(A2,Sheet2!A1:A25000,1,FALSE) "Jerry" wrote: I have two different files, both use the same unique identifiers. How can I ascertain which records are missing from the smaller file. For example: File A, has 28,225 different records. File B, has 14,205 different records. Which records from File A, are missing from File B? Thank you, Jerry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to compare multiple lists of data in excel | Excel Discussion (Misc queries) | |||
Compare two lists of data to find new entries | Excel Discussion (Misc queries) | |||
compare data in two lists to find matching entries | Excel Discussion (Misc queries) | |||
compare data in two lists to find matching entries | Excel Discussion (Misc queries) | |||
compare data in two lists to find matching entries | Excel Discussion (Misc queries) |