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".
I might be doing something wrong here. I added that to the end of my formula and it didn't work:
=FILTER(Duplicates,ISNUMBER(SEARCH(B1,Duplicates[Index]))+IF(B2<>"",ISNUMBER(SEARCH(B2,Duplicates[Index])))+IF(B3<>"",ISNUMBER(SEARCH(B3,Duplicates[Index]))),IF(B4<>"",ISNUMBER(SEARCH(B4,Duplicates[Index])*(ISERROR(SEARCH("Done",Duplicates[Notes]))))))I think you can remove "ISNUMBER(SEARCH(B4,Duplicates[Index])*" from that part of the formula. Since ISERROR(SEARCH("Done", Duplicates[Notes])) will you TRUE if it's an error ("Done" not found), or FALSE if it's not an error ("Done" was found), there's no need for the ISNUMBER check.
I tried removing the B4 ISNUMBER part of the formula and it still yielded the same thing (Done was still appearing)
