In the new Numbers (specifically version 3.2) when I add a single rule to filter a spreadsheet it works fine, but when I add a second rule with the "or..." button, it seems to undo the everything. I've tired with the "any filter" setting and the "all filters" setting (even though I'm sure I need "any").
Basically, I'm trying to apply a filter so Numbers only shows me any rows that do not contain certain words in a given column. I set this up with the first rule by choosing "Add a filter..." then "text" and then "text does not contain..." and I enter the word I want to filter out. When I hit return, the spreadsheet correctly hides any entries that contain that word. Then, under the rule, I hit the "or..." button and add go through the process of adding a second word that I also want to be hidden, but when I hit return to apply that rule, everything on the spreadsheet suddenly becomes visible, including the first rule I applied in the previous step. It's like they're canceling each other out. Again, I made sure the "Show rows that match:" drop-down is set to "any filter".
Anyone have an idea how to apply an "either/or" setting that can correctly work in Numbers?
Basically, I'm trying to apply a filter so Numbers only shows me any rows that do not contain certain words in a given column. I set this up with the first rule by choosing "Add a filter..." then "text" and then "text does not contain..." and I enter the word I want to filter out. When I hit return, the spreadsheet correctly hides any entries that contain that word. Then, under the rule, I hit the "or..." button and add go through the process of adding a second word that I also want to be hidden, but when I hit return to apply that rule, everything on the spreadsheet suddenly becomes visible, including the first rule I applied in the previous step. It's like they're canceling each other out. Again, I made sure the "Show rows that match:" drop-down is set to "any filter".
Anyone have an idea how to apply an "either/or" setting that can correctly work in Numbers?