<https://docs.google.com/spreadsheets/d/15xzwTJxxTuvWoMOgwGyMZk2BSknc9wD6iEUaZcOk03M/edit?usp=sharing>

I'm inputted some fake data in this sheet which shows you the results I want.

'Data' sheet has my raw data.

The 'Filter' sheet includes values I don't want to show in the result at all.

The 'Results' sheet shows the results I'm looking for.

I want to filter rows in my 'Data' sheet using a query formula that will only return rows where column A is unique or column A is the LAST occurrence of a duplicate value.

Then I want to remove any rows where column A contains a value found in the 'Filter!:A:A' column. 

The end results should look like the 'Results' sheet.