'if column not include some word
if column not include some word
I use this filter but not working:
=if(NOT(REGEXMATCH(A1:A6,"boy")),"")
But it works if I use just one row like that:
=if(NOT(REGEXMATCH(A1,"boy")),"")
return empty cell
I want to search in hole column A in has text boy and return empty cell
Solution 1:[1]
use:
=ARRAYFORMULA(IF(NOT(REGEXMATCH(A1:A6; "boy")); )
or:
=ARRAYFORMULA(IF(NOT(REGEXMATCH(A1:A6; "boy"));;"xxx")
if you want to output only true/false then drop the IF:
=INDEX(NOT(REGEXMATCH(A1:A6; "boy")))
or:
=FILTER(A1:A6; NOT(REGEXMATCH(A1:A6; "boy")))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |