Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to do case insensitive match with regexmatch in google sheets?

I'm trying to filter my sheet with

=filter({B:B}, regexmatch({B:B}, $A$1))

Is it possible to make regexmatch case insensitive?

like image 974
F. Vosnim Avatar asked Jan 03 '19 21:01

F. Vosnim


1 Answers

You can use:

=regexmatch($I1,"(?i)tex")
like image 69
Hasan A Yousef Avatar answered Sep 28 '22 04:09

Hasan A Yousef