我正在尋找一種將以下兩個查詢用于 1 的方法，我嘗試了很多，但每次都出錯。我也在谷歌上搜索過，但沒有找到。您的幫助將不勝感激
沒有 .1
=ARRAYFORMULA(UPPER(QUERY({IMPORTRANGE(Links!D10,"Sheet16!A3:AX1000"),IF(ISDATE_STRICT(IMPORTRANGE(Links!D10,"Sheet16!G3:G1000")),"No Show","Checked")}, "Select Col1, Col10, Col44, Col11, Col12, Col13, Col14, Col18, Col20, Col21, Col22, Col23, Col25, Col27, Col28, Col29, Col32, Col33, Col34, Col35, Col38, Col39, Col40, Col41, Col42, Col43 WHERE Col12 is not null ORDER BY Col10",0)))
不。2
=ARRAYFORMULA(UPPER(QUERY({IMPORTRANGE(Links!D11,"Sheet16!A3:AX1000"),IF(ISDATE_STRICT(IMPORTRANGE(Links!D11,"Sheet16!G3:G1000")),"No Show","Checked")}, "Select Col1, Col10, Col44, Col11, Col12, Col13, Col14, Col18, Col20, Col21, Col22, Col23, Col25, Col27, Col28, Col29, Col32, Col33, Col34, Col35, Col38, Col39, Col40, Col41, Col42, Col43 WHERE Col12 is not null ORDER BY Col10",0)))
uj5u.com熱心網友回復：
嘗試：
=ARRAYFORMULA(UPPER(QUERY({{
IMPORTRANGE(Links!D10, "Sheet16!A3:AX1000");
IMPORTRANGE(Links!D11, "Sheet16!A3:AX1000")}, IF(ISDATE_STRICT({
IMPORTRANGE(Links!D10, "Sheet16!G3:G1000");
IMPORTRANGE(Links!D11, "Sheet16!G3:G1000")}), "No Show", "Checked")},
"select Col1,Col10,Col44,Col11,Col12,Col13,Col14,Col18,Col20,Col21,Col22,Col23,Col25,Col27,Col28,Col29,Col32,Col33,Col34,Col35,Col38,Col39,Col40,Col41,Col42,Col43
where Col12 is not null
order by Col10", 0)))
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/457673.html
標籤：if 语句 谷歌表格 进口 谷歌表格公式 谷歌查询语言
下一篇：如何在圖表中包含空單元格？