Extracting selected records from longer list

H

Heidi

We have a spreadsheet containing the details of over 10,000 samples.
Recently, a client sent us a list of samples IDs that they have, and would
like us to send them the remaining samples that they DON'T have.

How can I pull out just records (sample IDs) for the samples that are NOT on
their list?

Thanks,

Heidi
 
D

Dave F

Use their list of IDs to run VLOOKUPs on your table of data. Any ID for
which a VLOOKUP returns #N/A would be one they don't have. See here for an
explanation of how VLOOKUP works

Dave
 
Top