Results 1 to 2 of 2

Thread: Label filters: Does not contain multiple keywords

  1. #1
    Acolyte thousand's Avatar
    Join Date
    Apr 2017
    Posts
    28
    Articles
    0
    Excel Version
    2010

    Label filters: Does not contain multiple keywords



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Conjurer Ed Kelly's Avatar
    Join Date
    Jul 2016
    Posts
    171
    Articles
    0
    Excel Version
    2016
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •