amy.excelhelp
New member
- Joined
- Mar 18, 2013
- Messages
- 1
- Reaction score
- 0
- Points
- 0
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.
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* |