Forum Discussion
Excel filter search removing previous filter selections, MacBook
Copied from a Reddit post, which describes my problem perfectly: "I have a data set and I want to filter for a series of values in a specific column, say Albert, George, Quellan, and Zelda. My issu...
May consider to use a Helper Column: Add a new column to your dataset and create a formula that checks if the value in the target column matches any of the names you're filtering for. For example, use a formula like =OR(A1="Albert", A1="George", A1="Quellan", A1="Zelda"). Then, filter the helper column for TRUE.