回答編集履歴
1
コードがうまく反映されないので修正
test
CHANGED
@@ -6,11 +6,9 @@
|
|
6
6
|
|
7
7
|
|
8
8
|
|
9
|
+
```GAS
|
9
10
|
|
10
|
-
|
11
|
-
```=IF(CONCATENATE(B2:E2,B4)="","",QUERY(IMPORTRANGE("売上マスタスプレッドシートのURL","'得意先別売上推移表'!A1:CI1100"),"Select Col6,Col9,Col68,Col67,Col66,Col69,Col70,Col71,Col72,Col73,Col74,Col75,Col76,Col77,Col78,Col79,Col80,Col81,Col85,Col86,Col87 where Col1 is not Null and Col68 like '"& IF(B2="","%","%"&B2&"%") &"' and Col67 like '"& IF(C2="","%","%"&C2&"%") &"' and Col66 like '"& IF(D2="","%","%"&D2&"%") &"' and Col9 like '"& IF(E2="","%","%"&E2&"%") & "' Order by " & VLOOKUP(B4,'マスタ'!C2:E13,2,FALSE) &VLOOKUP(B4,'マスタ'!C2:E13,3,FALSE)&" LIMIT 50",FALSE))
|
12
|
-
|
13
|
-
コード
|
11
|
+
=IF(CONCATENATE(B2:E2,B4)="","",QUERY(IMPORTRANGE("売上マスタスプレッドシートのURL","'得意先別売上推移表'!A1:CI1100"),"Select Col6,Col9,Col68,Col67,Col66,Col69,Col70,Col71,Col72,Col73,Col74,Col75,Col76,Col77,Col78,Col79,Col80,Col81,Col85,Col86,Col87 where Col1 is not Null and Col68 like '"& IF(B2="","%","%"&B2&"%") &"' and Col67 like '"& IF(C2="","%","%"&C2&"%") &"' and Col66 like '"& IF(D2="","%","%"&D2&"%") &"' and Col9 like '"& IF(E2="","%","%"&E2&"%") & "' Order by " & VLOOKUP(B4,'マスタ'!C2:E13,2,FALSE) &VLOOKUP(B4,'マスタ'!C2:E13,3,FALSE)&" LIMIT 50",FALSE))
|
14
12
|
|
15
13
|
```
|
16
14
|
|