回答編集履歴
2
抽出条件変更
test
CHANGED
|
@@ -1,10 +1,10 @@
|
|
|
1
1
|
```
|
|
2
2
|
=IFNA(query(
|
|
3
|
-
{IFERROR(IMPORTRANGE(I1,IF(C3,"新宿!A2:I
|
|
3
|
+
{IFERROR(IMPORTRANGE(I1,IF(C3,"新宿!A2:I")),QUERY({"","","","","","","","",""}));
|
|
4
|
-
IFERROR(IMPORTRANGE(I1,IF(C4,"渋谷!A2:I
|
|
4
|
+
IFERROR(IMPORTRANGE(I1,IF(C4,"渋谷!A2:I")),QUERY({"","","","","","","","",""}));
|
|
5
|
-
IFERROR(IMPORTRANGE(I1,IF(C5,"池袋!A2:I
|
|
5
|
+
IFERROR(IMPORTRANGE(I1,IF(C5,"池袋!A2:I")),QUERY({"","","","","","","","",""}))
|
|
6
6
|
} ,
|
|
7
|
-
"SELECT * WHERE Col1 >= "& A2 &" AND Col1 <= "& A5 &" ORDER BY Col1 ASC, Col2 ASC , Col3 ASC"), "参照なし")
|
|
7
|
+
"SELECT * WHERE Col1 >= "& A2 &" AND Col1 <= "& A5 &" ORDER BY Col1 ASC, Col2 ASC , Col3 ASC",1), "参照なし")
|
|
8
8
|
```
|
|
9
9
|
こちらでどうでしょうか？
|
|
10
10
|
チェックボックスを付けたもののみを抽出できます。
|
1
回答内容に誤りがあったため修正
test
CHANGED
|
@@ -1,9 +1,17 @@
|
|
|
1
1
|
```
|
|
2
|
-
=IF
|
|
2
|
+
=IFNA(query(
|
|
3
|
+
{IFERROR(IMPORTRANGE(I1,IF(C3,"新宿!A2:I5")),QUERY({"","","","","","","","",""}));
|
|
4
|
+
IFERROR(IMPORTRANGE(I1,IF(C4,"渋谷!A2:I5")),QUERY({"","","","","","","","",""}));
|
|
5
|
+
IFERROR(IMPORTRANGE(I1,IF(C5,"池袋!A2:I5")),QUERY({"","","","","","","","",""}))
|
|
6
|
+
} ,
|
|
7
|
+
"SELECT * WHERE Col1 >= "& A2 &" AND Col1 <= "& A5 &" ORDER BY Col1 ASC, Col2 ASC , Col3 ASC"), "参照なし")
|
|
3
8
|
```
|
|
9
|
+
こちらでどうでしょうか？
|
|
10
|
+
チェックボックスを付けたもののみを抽出できます。
|
|
4
11
|
|
|
12
|
+
|
|
5
|
-
こちらでエラーは解消できました。
|
|
13
|
+
~~こちらでエラーは解消できました。
|
|
6
|
-
何もチェックがない場合は、参照先がないので、「参照シート無し」の文字を表示させてます。
|
|
14
|
+
何もチェックがない場合は、参照先がないので、「参照シート無し」の文字を表示させてます。~~
|
|
7
15
|
|
|
8
16
|
|
|
9
17
|
|