Label filters: Does not contain multiple keywords

thousand

New member
Joined
Apr 2, 2017
Messages
30
Reaction score
0
Points
0
Excel Version(s)
2010
Hi

Is there a way to filter a pivot table to not show certain keywords (without VBA)?

Thanks

Example below, filter those that doesn't contain 'Apple', 'Orange'.

Row labels
Apple
Orange
Lemon
Berry
 
Consider using a slicer. And if a very long unique list perhaps index it alphabetically in M and bring that in as a second slicer
 
Back
Top