I'm trying to filter my sheet with
=filter({B:B}, regexmatch({B:B}, $A$1))
Is it possible to make regexmatch case insensitive?
You can use:
=regexmatch($I1,"(?i)tex")
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With