Google Sheets Query IN() Function

PHOTO

Thu Mar 31 2022 14:51:53 GMT+0000 (Coordinated Universal Time)

Saved by @hyfy #gquery #sheets

WHERE A MATCHES '"&TEXTJOIN("|",true,E1:E)&"'

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

#gquery #sheets

Google Sheets Query IN() Function

WHERE A MATCHES '"&TEXTJOIN("|",true,E1:E)&"'

#google #sheets

google sheets - How to refer to 'this' cell in a conditional formatting formula? - Web Applications Stack Exchange

https://webapps.stackexchange.com/questions/87025/how-to-refer-to-this-cell-in-a-conditional-formatting-formula

#google #sheets

How do you remove all text to the left of the last '/' on Google Sheets? - Quora

=index(split(B2,"/"),len(B2)-len(substitute(B2,"/",""))+1)

Browse more snippets >>