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?
Tjorven Hetzger is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2
You may try:
=filter(B1:J1,B2:J2,isna(xmatch(B1:J1,tocol(B6:C8,1))))