title: Filter table of entries and exclude any that are found in another table in Excel
body: <p>I have a table of staff data which I am filtering based on their employment status not being terminated and if they're a development role. To do this I have the following function :</p>
  <p><code>=FILTER(FILTER(StaffDetailsTbl,(StaffDetailsTbl[Employment Status]&lt;&gt;&quot;Employment Terminated&quot;)*(StaffDetailsTbl[Dev Role]=&quot;Yes&quot;))),{1,1,1,0,0,0,1,0,0})</code></p>
  <p>I have another table called AllStaffProjectAllocationTbl which has a matching Employee column and I'd like to check if the employee in the StaffDetailsTbl exists in AllStaffProjectAllocationTbl and if they do exclude them. I have first started to try and find if there is a match and include them only, with the view I can then flip this logic somehow to exclude the matches</p>
  <p><code>=FILTER(FILTER(StaffDetailsTbl,(StaffDetailsTbl[Employment Status]&lt;&gt;&quot;Employment Terminated&quot;)*(StaffDetailsTbl[Dev Role]=&quot;Yes&quot;)*(MATCH(StaffDetailsTbl[Employee],AllStaffProjectAllocationTbl,AllStaffProjectAllocationTbl[Employee]))),{1,1,1,0,0,0,1,0,0})</code></p>
  <p>Unfortunately this is giving me an error with the match. Does anyone have any advice on how I can approach this please?</p>