Item | Links |
Documentation / Tutorials | |
Industry / Case-studies |
|
Books |
|
Cheatsheet |
|
selectfromwhereorder by [desc]
=QUERY(A1:A,"Select * Where not A Matches '.*AB.*|.*DJ.*' ",1)=query(C323:C335,"Select C where not C contains 'soccer'")=QUERY(C:C,"Select C Where not C Matches '.*ezoic.*|.*soccer.*' ",1)
query(sheet2!A:G,"select A where G contains '"&L3&"'")=query(SX_Sessions!$B$2:$E$120,"select B,Dwhere E ='" &B3&"'AND C = '"&$B$1&"'")
=IMPORTXML(B3, "//a/@href")