Spreadsheet users have been asking for this for years, and it's a fair question: why can't one cell hold multiple values that all remain filterable? The user who posted this is not asking for a workaround. They are asking for a fundamental shift in how we think about data organization. Their example is telling: metformin is both a diabetes drug and a PCOS treatment. Forcing that reality into a single checkbox or a separate column for every possible indication is a failure of design, not a limitation of the user. The request is simple, but the implications are profound for anyone who manages complex datasets.
What this person is describing is a need for a tag-like system within Excel, similar to what Notion offers, but native to the Microsoft 365 environment. They want to select multiple properties from a dropdown list in a single cell, and then filter by any one of those properties without losing the others. That is not a niche request. It is the difference between a spreadsheet that stores data and one that actually serves the person using it. When you filter for diabetes, you should see every medication that treats diabetes, including those that also treat PCOS, and you should see all of their indications listed in the same cell. The current workaround of separate columns or manual checkboxes is not just inefficient; it creates a cognitive load that defeats the purpose of filtering in the first place.
The practical takeaway here is that the user is not asking for a new feature out of laziness. They are asking for a tool that matches the complexity of real-world information. In drug data, properties are rarely one-to-one. A single compound can have multiple indications, multiple side effects, multiple interactions. If your spreadsheet cannot represent that without you having to scroll through endless columns or lose track of which indication you have already filtered for, then the tool is not doing its job. The user's frustration is legitimate, and their proposed solution is the right one: a single column where each cell can hold multiple selectable tags, and where filtering respects the full set of values in that cell.
The good news is that this is achievable in Excel, but it requires a shift in approach. Instead of relying on the default filter options, you can use formulas and data validation to create a dynamic list that updates based on your selections. Or, more elegantly, you can use Power Query to unpivot your data, turning multiple indication columns into a single column with repeated rows for each drug. That way, filtering for diabetes will show you every row where diabetes appears, and the other indications remain visible in the same cell. It is not as straightforward as a native tag feature, but it is a practical, human-centered solution that respects the complexity of your data. The user is right to expect better, and with the right technique, they can build it today.