英文:
SQL query Google sheet - equals / not equal
问题
I would like to query db that will return all the DB that not equal to a range of values (in cells A1:A10)
Can I query not equal to a range?
QUERY(Cons!E2:T, "SELECT O, J WHERE O IS NOT IN A1:A10"))
英文:
I would like to query db that will returen all the DB that not equal to a range of values (in cells A1:A10)
Can i query not equal to a range ?
QUERY(Cons!E2:T,"SELECT O,J WHERE O IS NOT IN A1:A10"))
答案1
得分: 2
=QUERY(Cons!E2:T, "选择 O, J WHERE NOT O 匹配 '\\b" & TEXTJOIN("\\b|\\b", 1, A1:A10) & "\\b'")
英文:
Try this out:
=QUERY(Cons!E2:T,"SELECT O,J WHERE NOT O MATCHES '\b"&TEXTJOIN("\b|\b",1,A1:A10)&"\b'")
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论