title: Return rows where Column A is either unique or the last occurrence of duplicate values
body: <p><a href="https://docs.google.com/spreadsheets/d/15xzwTJxxTuvWoMOgwGyMZk2BSknc9wD6iEUaZcOk03M/edit?usp=sharing" rel="nofollow">https://docs.google.com/spreadsheets/d/15xzwTJxxTuvWoMOgwGyMZk2BSknc9wD6iEUaZcOk03M/edit?usp=sharing</a></p>
  
  <p>I'm inputted some fake data in this sheet which shows you the results I want.</p>
  
  <p>'Data' sheet has my raw data.</p>
  
  <p>The 'Filter' sheet includes values I don't want to show in the result at all.</p>
  
  <p>The 'Results' sheet shows the results I'm looking for.</p>
  
  <p>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.</p>
  
  <p>Then I want to remove any rows where column A contains a value found in the 'Filter!:A:A' column. </p>
  
  <p>The end results should look like the 'Results' sheet.</p>