Re: Remove duplicates by comparing two pairs of columns in separate tables
Again using an advanced filter, but the formula for the criteria is as follows:
Note that the two concatenated ranges (highlighted in blue) must be the same size and must cover your list that you wish to exclude. Then select the ranges for an advanced filter as normal.
Attached sample Workbook