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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
MS Excel 2000 - Compare two lists of data.
.. and was unsuccessful -a lot of false "True" ..
You're probably hit by data inconsistency, either text nums vs real nums issue and/or extraneous white spaces for textstring matches. It's quite common. Paste some representative sample data for both the lookup values and the reference col values where there are apparent matches which are not being returned correctly. -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- |
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) |