https://docs.google.com/spreadsheets/d/1HeldkN3k1H-WfyCusjOj4gocBtSeHkwKhDbNYDyYr5I/edit?usp=sharing
如本答案所示,在 S2 中追加两个查询不起作用。
={QUERY(C2:J, "SELECT D, I WHERE C <= date '"&TEXT(N1,"yyyy-mm-dd")&"'",0);QUERY(C2:J, "SELECT E, J WHERE C <= date '"&TEXT(N1,"yyyy-mm-dd")&"'",0)}
尝试:
=arrayformula({QUERY(C2:J, "SELECT D, I WHERE D IS NOT NULL AND C <= date '"&TEXT(N1,"yyyy-mm-dd")&"'",0);QUERY(C2:J, "SELECT E, J WHERE D IS NOT NULL AND C <= date '"&TEXT(N1,"yyyy-mm-dd")&"'",0)})
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句