{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["WorksheetFunction①","WorksheetFunction②","WorksheetFunction③","WorksheetFunction④","WorksheetFunction⑤","Sheet3"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":6,"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":"WorksheetFunction①","index":0,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,8,0,16]]}
["名前","数値",null,"名前","数値",null,null,null,"WorksheetFunctionの使い方①"]
["安東",39,null,{"$f":"_xlfn.UNIQUE(A2:A16)","v":"安東"}]
["安東",36,null,"安斉",null,null,null,null,"▢　A-B列のマスターからD列の名前をキーとして合計を出すマクロ"]
["安斉",55,null,"井原",null,null,null,null,"　　　WorksheetFunctionを使うと劇的にに短くなる"]
["安東",54,null,"安川",null,null,null,null,"　　①　素直にWorkSheetFuntionを使わず書くと、図1の通り長くなる。"]
["安斉",84,null,null,null,null,null,null,"　　②　WorkSheetFuntionを使うと、図2の通り短くなる。"]
["井原",42]
["井原",89]
["安斉",89]
["安東",46,null,null,null,null,null,null,"※　ワークシート関数は約480程あるが、WorksheetFunctionで"]
["安東",68,null,null,null,null,null,null,"　　 使えるのは約８割程度。"]
["井原",28]
["安東",70]
["井原",13]
["安川",16]
["安東",30]
["井原",93]
["安斉",59]
["安斉",96]
["安川",61]
["安東",17]
["安東",74]
["安川",78,null,null,null,null,null,null,null,null,null,null,"図1"]
["安斉",51]
["安斉",82]
["安川",66]
["井原",16]
["井原",69]
["安東",21]
["安東",28]
["安川",91,null,null,null,null,null,null,null,null,null,null,"図2"]
["安斉",68]
["安斉",88]

{"sheet":"WorksheetFunction②","index":1,"n_rows":501,"n_cols":13,"rows_kept":501,"cut":false,"hidden":false,"merged":[[0,8,0,16]]}
["商品","単価",null,"商品","単価",null,null,null,"WorksheetFunctionの使い方②"]
["A-107",null,null,"A-101",190]
["A-103",null,null,"A-102",200,null,null,null,"▢　D-E列のマスターからA列の商品をキーとしてB列に単価を入れるマクロ"]
["A-107",null,null,"A-103",210,null,null,null,"　　　①　普通にマクロを書けば、図2の様オブジェクト関数のSETを"]
["A-106",null,null,"A-104",220,null,null,null,"　　　　　　使用しなければならずマクロが難しくなる（図1）"]
["A-109",null,null,"A-105",230,null,null,null,"　　　②　WorksheetFunctionを使うと馴染みのVLookUp関数で簡単にできる（図2）"]
["A-101",null,null,"A-106",240]
["A-107",null,null,"A-107",250]
["A-102",null,null,"A-108",260]
["A-101",null,null,"A-109",270]
["A-105",null,null,"A-110",280]
["A-102"]
["A-103"]
["A-110"]
["A-101",null,null,null,null,null,null,null,null,null,null,null,"図1"]
["A-105"]
["A-110"]
["A-103"]
["A-105"]
["A-101"]
["A-106"]
["A-103"]
["A-108",null,null,null,null,null,null,null,null,null,null,null,"図2"]
["A-107"]
["A-103"]
["A-107"]
["A-106"]
["A-109"]
["A-101"]
["A-107"]
["A-102"]
["A-101"]
["A-105"]
["A-102"]
["A-103"]
["A-110"]
["A-101"]
["A-105"]
["A-110"]
["A-103"]
["A-105"]
["A-101"]
["A-106"]
["A-103"]
["A-108"]
["A-110"]
["A-101"]
["A-105"]
["A-110"]
["A-103"]
["A-105"]
["A-101"]
["A-106"]
["A-103"]
["A-108"]
["A-106"]
["A-109"]
["A-105"]
["A-106"]
["A-101"]
["A-110"]
["A-102"]
["A-107"]
["A-110"]
["A-103"]
["A-104"]
["A-108"]
["A-102"]
["A-107"]
["A-108"]
["A-109"]
["A-102"]
["A-107"]
["A-108"]
["A-106"]
["A-109"]
["A-102"]
["A-101"]
["A-109"]
["A-108"]
["A-107"]
["A-101"]
["A-110"]
["A-102"]
["A-104"]
["A-102"]
["A-102"]
["A-106"]
["A-104"]
["A-105"]
["A-104"]
["A-106"]
["A-101"]
["A-110"]
["A-104"]
["A-103"]
["A-102"]
["A-107"]
["A-102"]
["A-102"]
["A-106"]
["A-105"]
["A-103"]
["A-104"]
["A-110"]
["A-104"]
["A-106"]
["A-106"]
["A-101"]
["A-105"]
["A-103"]
["A-105"]
["A-108"]
["A-101"]
["A-104"]
["A-110"]
["A-102"]
["A-108"]
["A-101"]
["A-101"]
["A-108"]
["A-110"]
["A-103"]
["A-109"]
["A-104"]
["A-108"]
["A-108"]
["A-104"]
["A-105"]
["A-104"]
["A-101"]
["A-104"]
["A-101"]
["A-104"]
["A-104"]
["A-106"]
["A-104"]
["A-101"]
["A-107"]
["A-105"]
["A-102"]
["A-102"]
["A-101"]
["A-105"]
["A-107"]
["A-110"]
["A-107"]
["A-103"]
["A-108"]
["A-106"]
["A-106"]
["A-108"]
["A-107"]
["A-104"]
["A-107"]
["A-106"]
["A-101"]
["A-108"]
["A-106"]
["A-105"]
["A-106"]
["A-105"]
["A-106"]
["A-106"]
["A-102"]
["A-101"]
["A-103"]
["A-106"]
["A-108"]
["A-109"]
["A-105"]
["A-108"]
["A-102"]
["A-102"]
["A-103"]
["A-101"]
["A-105"]
["A-103"]
["A-102"]
["A-110"]
["A-104"]
["A-104"]
["A-101"]
["A-104"]
["A-103"]
["A-105"]
["A-110"]
["A-105"]
["A-103"]
["A-103"]
["A-102"]
["A-105"]
["A-106"]
["A-103"]
["A-101"]
["A-105"]
["A-107"]
["A-102"]
["A-109"]
["A-108"]
["A-102"]
["A-104"]
["A-110"]
["A-108"]
["A-110"]
["A-110"]
["A-104"]
["A-104"]
["A-109"]
["A-109"]
["A-102"]
["A-105"]
["A-106"]
["A-103"]
["A-105"]
["A-110"]
["A-101"]
["A-106"]
["A-108"]
["A-109"]
["A-107"]
["A-109"]
["A-102"]
["A-108"]
["A-106"]
["A-103"]
["A-110"]
["A-109"]
["A-103"]
["A-106"]
["A-110"]
["A-106"]
["A-104"]
["A-109"]
["A-102"]
["A-101"]
["A-107"]
["A-106"]
["A-109"]
["A-102"]
["A-104"]
["A-102"]
["A-103"]
["A-101"]
["A-101"]
["A-101"]
["A-101"]
["A-107"]
["A-104"]
["A-104"]
["A-110"]
["A-106"]
["A-109"]
["A-101"]
["A-105"]
["A-105"]
["A-109"]
["A-104"]
["A-103"]
["A-109"]
["A-106"]
["A-106"]
["A-105"]
["A-107"]
["A-103"]
["A-101"]
["A-102"]
["A-110"]
["A-105"]
["A-109"]
["A-102"]
["A-106"]
["A-103"]
["A-102"]
["A-110"]
["A-101"]
["A-109"]
["A-110"]
["A-108"]
["A-102"]
["A-106"]
["A-102"]
["A-110"]
["A-104"]
["A-103"]
["A-110"]
["A-105"]
["A-104"]
["A-110"]
["A-110"]
["A-102"]
["A-102"]
["A-106"]
["A-108"]
["A-104"]
["A-105"]
["A-106"]
["A-102"]
["A-110"]
["A-105"]
["A-102"]
["A-101"]
["A-106"]
["A-109"]
["A-102"]
["A-101"]
["A-107"]
["A-108"]
["A-103"]
["A-109"]
["A-108"]
["A-109"]
["A-110"]
["A-108"]
["A-110"]
["A-105"]
["A-101"]
["A-106"]
["A-105"]
["A-109"]
["A-106"]
["A-109"]
["A-109"]
["A-101"]
["A-110"]
["A-109"]
["A-110"]
["A-101"]
["A-106"]
["A-107"]
["A-102"]
["A-102"]
["A-108"]
["A-109"]
["A-105"]
["A-104"]
["A-103"]
["A-101"]
["A-107"]
["A-104"]
["A-107"]
["A-106"]
["A-105"]
["A-107"]
["A-107"]
["A-110"]
["A-110"]
["A-105"]
["A-104"]
["A-105"]
["A-106"]
["A-101"]
["A-106"]
["A-103"]
["A-104"]
["A-104"]
["A-109"]
["A-106"]
["A-103"]
["A-106"]
["A-105"]
["A-105"]
["A-105"]
["A-107"]
["A-104"]
["A-109"]
["A-107"]
["A-107"]
["A-107"]
["A-109"]
["A-110"]
["A-108"]
["A-110"]
["A-101"]
["A-108"]
["A-109"]
["A-105"]
["A-108"]
["A-103"]
["A-105"]
["A-105"]
["A-103"]
["A-103"]
["A-103"]
["A-109"]
["A-102"]
["A-104"]
["A-105"]
["A-108"]
["A-105"]
["A-102"]
["A-107"]
["A-109"]
["A-109"]
["A-103"]
["A-102"]
["A-101"]
["A-109"]
["A-106"]
["A-109"]
["A-108"]
["A-106"]
["A-102"]
["A-110"]
["A-104"]
["A-108"]
["A-104"]
["A-106"]
["A-110"]
["A-110"]
["A-110"]
["A-102"]
["A-105"]
["A-107"]
["A-109"]
["A-107"]
["A-109"]
["A-110"]
["A-108"]
["A-110"]
["A-101"]
["A-108"]
["A-109"]
["A-105"]
["A-108"]
["A-103"]
["A-105"]
["A-105"]
["A-103"]
["A-103"]
["A-103"]
["A-109"]
["A-102"]
["A-104"]
["A-105"]
["A-108"]
["A-105"]
["A-102"]
["A-107"]
["A-109"]
["A-109"]
["A-103"]
["A-102"]
["A-101"]
["A-109"]
["A-106"]
["A-109"]
["A-108"]
["A-106"]
["A-102"]
["A-110"]
["A-104"]
["A-108"]
["A-104"]
["A-106"]
["A-110"]
["A-110"]
["A-110"]
["A-102"]
["A-105"]
["A-107"]
["A-109"]
["A-107"]
["A-109"]
["A-110"]
["A-108"]
["A-110"]
["A-101"]
["A-108"]
["A-109"]
["A-105"]
["A-108"]
["A-103"]
["A-105"]
["A-105"]
["A-103"]
["A-103"]
["A-103"]
["A-109"]
["A-102"]
["A-104"]
["A-105"]
["A-108"]
["A-105"]
["A-102"]
["A-107"]
["A-109"]
["A-109"]
["A-103"]
["A-102"]
["A-101"]
["A-109"]
["A-106"]
["A-109"]
["A-108"]
["A-106"]
["A-102"]
["A-110"]
["A-104"]
["A-108"]
["A-104"]

{"sheet":"WorksheetFunction③","index":2,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,8,0,16]]}
["名前",null,"名前",null,null,null,null,null,"WorksheetFunctionの使い方③"]
["田中"]
["広瀬",null,null,null,null,null,null,null,"▢　C2に入力した名前がA列に無ければ、A列の最後に追加するマクロ"]
["桜井",null,null,null,null,null,null,null,"　　①　普通にマクロを書けば、図2の様に長くなる（図1）"]
["西野",null,null,null,null,null,null,null,"　　②　WorksheetFunctionを使うとCountIf関数で簡単にできる（図2）"]
["橋本"]
["松岡"]
["白石"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"図1"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"図2"]

{"sheet":"WorksheetFunction④","index":3,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,8,0,16]]}
["名前","数値",null,"第１位",null,null,null,null,"WorksheetFunctionの使い方④"]
["田中",93,null,"第２位"]
["広瀬",89,null,"第３位",null,null,null,null,"▢　A-B列のマスタの中から数値の順位(１-3位)の数値をE列に入れるマクロ（図1）"]
["桜井",96,null,null,null,null,null,null,"　　①　Large関数を使えば図の通り簡単にできる"]
["西野",87]
["橋本",94]
["松岡",86]
["白石",82]

{"sheet":"WorksheetFunction⑤","index":4,"n_rows":501,"n_cols":13,"rows_kept":501,"cut":false,"hidden":false,"merged":[[0,8,0,16],[12,3,12,4]]}
["商品","単価",null,"商品","単価",null,null,null,"WorksheetFunctionの使用上の注意点"]
["A-107",180,null,"A-101",190]
["A-101",190,null,"A-102",440,null,null,null,"▢　A-106xxの様にD列のマスタにデータが無い場合マクロを実行するとエラーが出る場合の対処方。"]
["A-103",820,null,"A-103",820,null,null,null,"　　①　マクロを実行するとエラーが出る（図1）"]
["A-106xx",null,null,"A-104",840,null,null,null,"　　②　エラー処理をするとエラーが回避される（図2）"]
["A-102",null,null,"A-105",100]
["A-103",null,null,"A-106",270]
["A-105",null,null,"A-107",180]
["A-106",null,null,"A-108",690]
["A-103",null,null,"A-109",970]
["A-103",null,null,"A-110",390]
["A-107"]
["A-108"]
["A-109"]
["A-110",null,null,null,null,null,null,null,null,null,null,null,"図1"]
["A-110"]
["A-103"]
["A-110"]
["A-107"]
["A-110"]
["A-102"]
["A-110"]
["A-105"]
["A-105"]
["A-101",null,null,null,null,null,null,null,null,null,null,null,"図2"]
["A-102"]
["A-109"]
["A-101"]
["A-103"]
["A-104"]
["A-108"]
["A-105"]
["A-110"]
["A-107"]
["A-103"]
["A-107"]
["A-106"]
["A-109"]
["A-101"]
["A-107"]
["A-102"]
["A-101"]
["A-105"]
["A-102"]
["A-103"]
["A-110"]
["A-101"]
["A-105"]
["A-110"]
["A-103"]
["A-105"]
["A-101"]
["A-106"]
["A-103"]
["A-108"]
["A-106"]
["A-109"]
["A-105"]
["A-106"]
["A-101"]
["A-110"]
["A-102"]
["A-107"]
["A-110"]
["A-103"]
["A-104"]
["A-108"]
["A-102"]
["A-107"]
["A-108"]
["A-109"]
["A-102"]
["A-107"]
["A-108"]
["A-106"]
["A-109"]
["A-102"]
["A-101"]
["A-109"]
["A-108"]
["A-107"]
["A-101"]
["A-110"]
["A-102"]
["A-104"]
["A-102"]
["A-102"]
["A-106"]
["A-104"]
["A-105"]
["A-104"]
["A-106"]
["A-101"]
["A-110"]
["A-104"]
["A-103"]
["A-102"]
["A-107"]
["A-102"]
["A-102"]
["A-106"]
["A-105"]
["A-103"]
["A-104"]
["A-110"]
["A-104"]
["A-106"]
["A-106"]
["A-101"]
["A-105"]
["A-103"]
["A-105"]
["A-108"]
["A-101"]
["A-104"]
["A-110"]
["A-102"]
["A-108"]
["A-101"]
["A-101"]
["A-108"]
["A-110"]
["A-103"]
["A-109"]
["A-104"]
["A-108"]
["A-108"]
["A-104"]
["A-105"]
["A-104"]
["A-101"]
["A-104"]
["A-101"]
["A-104"]
["A-104"]
["A-106"]
["A-104"]
["A-101"]
["A-107"]
["A-105"]
["A-102"]
["A-102"]
["A-101"]
["A-105"]
["A-107"]
["A-110"]
["A-107"]
["A-103"]
["A-108"]
["A-106"]
["A-106"]
["A-108"]
["A-107"]
["A-104"]
["A-107"]
["A-106"]
["A-101"]
["A-108"]
["A-106"]
["A-105"]
["A-106"]
["A-105"]
["A-106"]
["A-106"]
["A-102"]
["A-101"]
["A-103"]
["A-106"]
["A-108"]
["A-109"]
["A-105"]
["A-108"]
["A-102"]
["A-102"]
["A-103"]
["A-101"]
["A-105"]
["A-103"]
["A-102"]
["A-110"]
["A-104"]
["A-104"]
["A-101"]
["A-104"]
["A-103"]
["A-105"]
["A-110"]
["A-105"]
["A-103"]
["A-103"]
["A-102"]
["A-105"]
["A-106"]
["A-103"]
["A-101"]
["A-105"]
["A-107"]
["A-102"]
["A-109"]
["A-108"]
["A-102"]
["A-104"]
["A-110"]
["A-108"]
["A-110"]
["A-110"]
["A-104"]
["A-104"]
["A-109"]
["A-109"]
["A-102"]
["A-105"]
["A-106"]
["A-103"]
["A-105"]
["A-110"]
["A-101"]
["A-106"]
["A-108"]
["A-109"]
["A-107"]
["A-109"]
["A-102"]
["A-108"]
["A-106"]
["A-103"]
["A-110"]
["A-109"]
["A-103"]
["A-106"]
["A-110"]
["A-106"]
["A-104"]
["A-109"]
["A-102"]
["A-101"]
["A-107"]
["A-106"]
["A-109"]
["A-102"]
["A-104"]
["A-102"]
["A-103"]
["A-101"]
["A-101"]
["A-101"]
["A-101"]
["A-107"]
["A-104"]
["A-104"]
["A-110"]
["A-106"]
["A-109"]
["A-101"]
["A-105"]
["A-105"]
["A-109"]
["A-104"]
["A-103"]
["A-109"]
["A-106"]
["A-106"]
["A-105"]
["A-107"]
["A-103"]
["A-101"]
["A-102"]
["A-110"]
["A-105"]
["A-109"]
["A-102"]
["A-106"]
["A-103"]
["A-102"]
["A-110"]
["A-101"]
["A-109"]
["A-110"]
["A-108"]
["A-102"]
["A-106"]
["A-102"]
["A-110"]
["A-104"]
["A-103"]
["A-110"]
["A-105"]
["A-104"]
["A-110"]
["A-110"]
["A-102"]
["A-102"]
["A-106"]
["A-108"]
["A-104"]
["A-105"]
["A-106"]
["A-102"]
["A-110"]
["A-105"]
["A-102"]
["A-101"]
["A-106"]
["A-109"]
["A-102"]
["A-101"]
["A-107"]
["A-108"]
["A-103"]
["A-109"]
["A-108"]
["A-109"]
["A-110"]
["A-108"]
["A-110"]
["A-105"]
["A-101"]
["A-106"]
["A-105"]
["A-109"]
["A-106"]
["A-109"]
["A-109"]
["A-101"]
["A-110"]
["A-109"]
["A-110"]
["A-101"]
["A-106"]
["A-107"]
["A-102"]
["A-102"]
["A-108"]
["A-109"]
["A-105"]
["A-104"]
["A-103"]
["A-101"]
["A-107"]
["A-104"]
["A-107"]
["A-106"]
["A-105"]
["A-107"]
["A-107"]
["A-110"]
["A-110"]
["A-105"]
["A-104"]
["A-105"]
["A-106"]
["A-101"]
["A-106"]
["A-103"]
["A-104"]
["A-104"]
["A-109"]
["A-106"]
["A-103"]
["A-106"]
["A-105"]
["A-105"]
["A-105"]
["A-107"]
["A-104"]
["A-109"]
["A-107"]
["A-107"]
["A-107"]
["A-109"]
["A-110"]
["A-108"]
["A-110"]
["A-101"]
["A-108"]
["A-109"]
["A-105"]
["A-108"]
["A-103"]
["A-105"]
["A-105"]
["A-103"]
["A-103"]
["A-103"]
["A-109"]
["A-102"]
["A-104"]
["A-105"]
["A-108"]
["A-105"]
["A-102"]
["A-107"]
["A-109"]
["A-109"]
["A-103"]
["A-102"]
["A-101"]
["A-109"]
["A-106"]
["A-109"]
["A-108"]
["A-106"]
["A-102"]
["A-110"]
["A-104"]
["A-108"]
["A-104"]
["A-106"]
["A-110"]
["A-110"]
["A-110"]
["A-102"]
["A-105"]
["A-107"]
["A-109"]
["A-107"]
["A-109"]
["A-110"]
["A-108"]
["A-110"]
["A-101"]
["A-108"]
["A-109"]
["A-105"]
["A-108"]
["A-103"]
["A-105"]
["A-105"]
["A-103"]
["A-103"]
["A-103"]
["A-109"]
["A-102"]
["A-104"]
["A-105"]
["A-108"]
["A-105"]
["A-102"]
["A-107"]
["A-109"]
["A-109"]
["A-103"]
["A-102"]
["A-101"]
["A-109"]
["A-106"]
["A-109"]
["A-108"]
["A-106"]
["A-102"]
["A-110"]
["A-104"]
["A-108"]
["A-104"]
["A-106"]
["A-110"]
["A-110"]
["A-110"]
["A-102"]
["A-105"]
["A-107"]
["A-109"]
["A-107"]
["A-109"]
["A-110"]
["A-108"]
["A-110"]
["A-101"]
["A-108"]
["A-109"]
["A-105"]
["A-108"]
["A-103"]
["A-105"]
["A-105"]
["A-103"]
["A-103"]
["A-103"]
["A-109"]
["A-102"]
["A-104"]
["A-105"]
["A-108"]
["A-105"]
["A-102"]
["A-107"]
["A-109"]
["A-109"]
["A-103"]
["A-102"]
["A-101"]
["A-109"]
["A-106"]
["A-109"]
["A-108"]
["A-106"]
["A-102"]
["A-110"]
["A-104"]
["A-108"]
["A-104"]

{"sheet":"Sheet3","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}