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