Results 1 to 2 of 2

Thread: Advanced Filters Not Working

  1. #1

    Question Advanced Filters Not Working



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

    Hi,

    I'm trying to apply advanced filters to a list of words and phrases in Excel in order to segment and categorize them into groups. For some reason, my filters are not working even though I made sure I have selected the right List and Criteria range. Below are the two criteria that I'd used simultaneously in a filter - I want the filter to extract words/phrases from my list that does not include the word "common" but does include the word "text book." Can anyone help and let me know what else I can do to troubleshoot? Thanks.

    Criterion 1 Criterion 2
    <>*common* =*text*book*

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    If you enter the column header in 2 horizontally adjacent cells, then below each put each criteria, then try the advance filtering....

    so if the column header is "Phrases", and this is column A, then say in X1 and Y1 enter the header "Phrases", then in X2 enter criterion 1, and in Y2 enter criterion 2.


Tags for this Thread

Posting Permissions

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