delete unwanted IDs

Hi,

enter this formula into cell C2:

=IF(ISNA(MATCH(A2,B:B,0)),"",A2)

Copy down to row 538. Then add a header in C1 and sort by that column. The result is the list of codes that are in column A AND in column B.

See attached file.

regards,