質問編集履歴
3
タグ
test
CHANGED
|
File without changes
|
test
CHANGED
|
File without changes
|
2
B)
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -20,7 +20,7 @@
|
|
|
20
20
|
|
|
21
21
|
B)
|
|
22
22
|
|
|
23
|
-
=query(IMPORTRANGE("●●●●●●●","goal!A:AF"),"select min(Col31) where Col2 = '"&C2&"' and Col24="&C4&" and Col26="&C9&",1)
|
|
23
|
+
=query(IMPORTRANGE("●●●●●●●","goal!A:AF"),"select min(Col31) where Col2 = '"&C2&"' and Col24="&C4&" and Col26="&C9&"",1)
|
|
24
24
|
|
|
25
25
|
|
|
26
26
|
|
1
B)シングル、ダブルクオーテーションが余計に入っている個所がありましたので修正してます。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -20,7 +20,7 @@
|
|
|
20
20
|
|
|
21
21
|
B)
|
|
22
22
|
|
|
23
|
-
=query(IMPORTRANGE("●●●●●●●","goal!A:AF"),"select min(Col31) where Col2 = '"&C2&"' and Col24="&C4&"
|
|
23
|
+
=query(IMPORTRANGE("●●●●●●●","goal!A:AF"),"select min(Col31) where Col2 = '"&C2&"' and Col24="&C4&" and Col26="&C9&",1)
|
|
24
24
|
|
|
25
25
|
|
|
26
26
|
|