{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["テーブル内データ検索","<setting>","<使用説明書>"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"テーブル内データ検索","index":0,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,3,2,4]]}
["# 当ツールの使用に関しては、<使用説明書> シートを確認してください"]
[]
[]
[]
[]
[]
["No.","区分コード","区分名称","問合せ概要","問合せ詳細","回答内容","問合せ日","問合せ者","回答者","備考","作業列"]

{"sheet":"<setting>","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"▼検索対象を変更する場合は対象の列をカンマ区切りで指定してください。"]
[null,"検索する項目の列","検索条件","検索条件","条件の対象"]
[null,"A,B,C,D,E,F,G,H,I,J",null,{"$f":"VLOOKUP(1,テーブル1[],2)","v":"AND条件"},{"$f":"VLOOKUP(1,テーブル2[],2)","v":"一つのセル"}]
[null,"例）A,B,C,E,J"]
[null,null,null,"表示管理列","検索条件"]
[null,null,null,{"$f":"SUBTOTAL(3,テーブル1[[#This Row],[検索条件]])","v":1},"AND条件"]
[null,null,null,{"$f":"SUBTOTAL(3,テーブル1[[#This Row],[検索条件]])","v":0},"OR条件"]
[]
[null,null,null,"表示管理列","条件の対象"]
[null,null,null,{"$f":"SUBTOTAL(3,テーブル2[[#This Row],[条件の対象]])","v":0},"複数項目"]
[null,null,null,{"$f":"SUBTOTAL(3,テーブル2[[#This Row],[条件の対象]])","v":1},"一つのセル"]

{"sheet":"<使用説明書>","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}