title: What is the function for filtering data that is not in a list in google sheets?
body: <p>I haven't made a spreadsheet with slightly more advanced formulas for over a year.
  I've been trying to do this for hours, searching the internet. But I haven't found anything that works as I need it. it should be simple, but I need help.</p>
  <p>I have 3 tables:</p>
  <ol>
  <li><strong>requisitions</strong> (responses arriving from a form)</li>
  <li><strong>completed</strong> (requisitions completed)</li>
  <li><strong>pendencies</strong> I would like this spreadsheet to list all the requisitions data that are in the table: <strong>requisitions</strong>, but that are not yet in the table: <strong>completed</strong>.</li>
  </ol>
  <p>spreadsheet link: <a href="https://docs.google.com/spreadsheets/d/10EhQllVUSaxAMaLYAfzEa9loHWsEtluO4zIblA03Yxo/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/10EhQllVUSaxAMaLYAfzEa9loHWsEtluO4zIblA03Yxo/edit?usp=sharing</a></p>
  <p>Note: All my requests have a sequential ID in <strong>column A</strong>. It would be just a comparison de ids, bringing the data as the functions: query, filter for example.</p>