There's a quiet frustration that builds when you know exactly what you want a spreadsheet to do, yet the tool keeps outsmarting you. This reader's question about hiding specific flight codes while preserving others is a perfect example. They're not asking for a miracle. They just want to filter out SQ, AC, and NZ flights, but keep any row where NZ appears alongside QF. That's a logical, specific rule. And their confusion about why some flights disappear when they shouldn't is entirely justified. The filter isn't broken. It's just not built to think in combinations.
What this reader is running into is a classic limitation of basic filtering. Standard filters work on a row-by-row basis, showing you what matches a condition and hiding everything else. But when your condition involves relationships between values in the same row, a simple filter stops being enough. You're no longer asking "which rows contain NZ?" You're asking "which rows contain NZ but also QF, and therefore need to stay visible?" That's not a filter. That's logic. And logic requires a formula.
The practical answer here is to add a helper column. A simple formula like `=OR(ISNUMBER(SEARCH("QF",A2)), AND(ISNUMBER(SEARCH("NZ",A2)), ISNUMBER(SEARCH("QF",A2))))` might sound technical, but it's really just translating your rule into something the spreadsheet can act on. Once that column exists, you filter on it instead of the raw flight codes. You gain control without losing nuance. This is the kind of workaround that separates people who wrestle with spreadsheets from those who direct them.
What we appreciate about this question is that it shows a user who's paying attention. They've noticed the inconsistency. They're not giving up. They're asking for a better way. That's the mindset that leads to real fluency with data tools. And while the immediate fix involves a formula, the deeper takeaway is this: when a tool doesn't do what you need, the answer isn't to fight it harder. It's to add a layer of logic that bridges the gap between what you see and what you mean. Start with a helper column. Test it on a few rows. Then filter with confidence. That's how you move from guessing to directing.