這是我目前的完美運作公式......
=QUERY({IMPORTRANGE("https://docs.google.com/spreadsheets/d/1BNomeoTxYiT4A1A0i8jhRIPtTfZN0GtbQQ4Intp7lMY", "'MASTER'!A2:Z100");IMPORTRANGE("https://docs.google.com/spreadsheets/d/1BNomeoTxYiT4A1A0i8jhRIPtTfZN0GtbQQ4Intp7lMY", "'SPOTS'!A2:Z100")},"select * where LOWER(Col1) contains '"&lower(Structure!N$8)&"' and Col2 = date '"&TEXT(Structure!M$8,"yyyy-mm-dd")&"'",1)
我想要做的就是按 Col5 升序排序。我嘗試以多種方式添加它并不斷收到錯誤訊息。任何人都可以幫助編輯此公式以添加“按 col5 asc 排序”？
uj5u.com熱心網友回復：
嘗試：
=QUERY({
IMPORTRANGE("1BNomeoTxYiT4A1A0i8jhRIPtTfZN0GtbQQ4Intp7lMY", "'MASTER'!A2:Z100");
IMPORTRANGE("1BNomeoTxYiT4A1A0i8jhRIPtTfZN0GtbQQ4Intp7lMY", "'SPOTS'!A2:Z100")},
"where LOWER(Col1) contains '"&LOWER(Structure!N$8)&"'
and Col2 = date '"&TEXT(Structure!M$8, "yyyy-mm-dd")&"'
order by Col5 asc", 1)
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/355748.html
標籤：谷歌表格