Filter Google Sheets

Filter Google Sheets

Your page summary goes here.

filter one word (contents of D2) =filter(Sheet1!A2:A,REGEXMATCH(Sheet1!A2:A,D2)=false, Sheet1!A2:A<>"")

filter two words (contents of D2 and 3301) =filter(Sheet1!A2:A,REGEXMATCH(Sheet1!A2:A,D2&"|3301")=false, Sheet1!A2:A<>"")

filter list (contents of D2:D) =filter(Sheet1!A2:A,REGEXMATCH(Sheet1!A2:A,TEXTJOIN("|",true,D2:D))=false, Sheet1!A2:A<>"")

THEME_QUARK.BLOG.ITEM.PREV_POST THEME_QUARK.BLOG.ITEM.NEXT_POST