View the original community article here
Last tested: Mar 5, 2021
We can do it with merged results! Create the main query and then merge to the query for the "not in" part. The second explore's fields will be null when it's "not in" so you can use a yesno table calculation to find those and remove the ones that aren't null. Keep in mind that this is limited to 5K results on either side of the merge.
This content is subject to limited support.