I struggle with the following problem:
I have a row in Google Sheets that I want to filter for the values that have an entry below them in the second row. Then I want to further filter for only those values that don’t appear in a range with very different dimensions.

I hope this is clear, you can find a minimal example in this sheet: https://docs.google.com/spreadsheets/d/1v1OKg-iQ92KsYHabCzkd6A7980H4uet34XhJRqGR0D0/edit?usp=sharing

I guess I just have to add an additional condition to the filter function, but have struggled to find a suitable one because FILTER expects conditions with the same range as the range to be filtered. Do you have a simple suggestion for how to do this, preferably without using “intermediate” cells or scripting?

Thanks a lot!