Forum Discussion
Filtering Out Rows With Specific Text When Filtering With Multiple Criteria
I have a workbook to find duplicates in content that is housed on our site. This workbook has different worksheets that are combined into one using Power Query and each instance is tracked using an i...
Since SEARCH returns an error if the search text isn't found, you could use =ISERROR(SEARCH("Done", Duplicates[Notes])). This will be TRUE for any that don't include the word "Done".