如果/过滤子句查询公式（嵌入了arrayformula）
我在Gsheets上有一个响应表，其中有100多列/问题可以通过Yes或否。
以下公式 - 允许我从一张纸上导出回答是或否的问题：
=QUERY('Module 1 Responses'!$A$2:$AS,"SELECT "&join(",",arrayformula(SUBSTITUTE(ADDRESS(1,MATCH($A$1:$W$1,'Module 1 Responses'!$A$1:$AS$1,0),4),1,""))))
我想在此公式中添加“ if”或“ filter”子句，以便我只能看到“否” s或那将将所有“是”值转换为空白 - 如果可能的话，
请在此处查看带有模拟数据的表： https://docs.google.com/spreadsheets/d/1vbrkvwba5jxcrqxcrqxwb7qgfjhgcbbbfjcbbfjcmcawv7b1yqpci/edit
？事先感谢您的帮助！
I have a response sheet on GSheets with over 100 columns/questions that can either be responded by Yes or No. If the candidate answers no they will have to fill in a freetext question.
The following formula - allows me to export the questions that were answered Yes or No from one sheet to another:
=QUERY('Module 1 Responses'!$A$2:$AS,"SELECT "&join(",",arrayformula(SUBSTITUTE(ADDRESS(1,MATCH($A$1:$W$1,'Module 1 Responses'!$A$1:$AS$1,0),4),1,""))))
I would like to add an "if" or a "filter" clause to this formula so that I can only see the "No"s or that would convert all the "Yes" values to blank - if at all possible
Please see sheet with mock data here: https://docs.google.com/spreadsheets/d/1VBrkVwBa5jXcrQXwB7QGFJhgcbBfjcmCawV7B1YqPcI/edit?usp=sharing
The tab I am working on is called "Action Plan". Thanks in advance for your help!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
尝试：
try: