質問編集履歴
3
タグ
title
CHANGED
|
File without changes
|
body
CHANGED
|
File without changes
|
2
B)
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -9,6 +9,6 @@
|
|
|
9
9
|
=query(IMPORTRANGE("●●●●●●●","goal!A:AF"),"select min(Col31) where Col2 = '07' and Col24=2019 and Col26=4",1)
|
|
10
10
|
↓
|
|
11
11
|
B)
|
|
12
|
-
=query(IMPORTRANGE("●●●●●●●","goal!A:AF"),"select min(Col31) where Col2 = '"&C2&"' and Col24="&C4&" and Col26="&C9&",1)
|
|
12
|
+
=query(IMPORTRANGE("●●●●●●●","goal!A:AF"),"select min(Col31) where Col2 = '"&C2&"' and Col24="&C4&" and Col26="&C9&"",1)
|
|
13
13
|
|
|
14
14
|
正しい記述をご教示いただけないでしょうか。
|
1
B)シングル、ダブルクオーテーションが余計に入っている個所がありましたので修正してます。
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -9,6 +9,6 @@
|
|
|
9
9
|
=query(IMPORTRANGE("●●●●●●●","goal!A:AF"),"select min(Col31) where Col2 = '07' and Col24=2019 and Col26=4",1)
|
|
10
10
|
↓
|
|
11
11
|
B)
|
|
12
|
-
=query(IMPORTRANGE("●●●●●●●","goal!A:AF"),"select min(Col31) where Col2 = '"&C2&"' and Col24="&C4&"
|
|
12
|
+
=query(IMPORTRANGE("●●●●●●●","goal!A:AF"),"select min(Col31) where Col2 = '"&C2&"' and Col24="&C4&" and Col26="&C9&",1)
|
|
13
13
|
|
|
14
14
|
正しい記述をご教示いただけないでしょうか。
|