{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Hide Formula","Protected","Hidden","Prevent Deletion"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Hide Formula","index":0,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,9],[7,6,7,9]]}
[]
[null,"Hide Formula in Extracting Data from Range by Array with VBA"]
[]
[null,"ID","Name","Marks","Department",null,null,"Start Value",80]
[null,1,"Joe",60,"Math",null,null,"End Value",100]
[null,2,"Josh",30,"Physics",null,null,"Column",3]
[null,3,"Johnny",80,"Biology"]
[null,4,"Mike",55,"Chemistry",null,"Search Result"]
[null,5,"David",87,"Physics"]
[null,6,"Chris",95,"Physics",null,"ID","Name","Marks","Department"]
[null,7,"Kane",100,"Math",null,{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS(G11:$G$11)),COLUMNS($A$1:A1))","v":3},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G11:H$11)),COLUMNS($A$1:B1))","v":"Johnny"},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G11:I$11)),COLUMNS($A$1:C1))","v":80},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G11:J$11)),COLUMNS($A$1:D1))","v":"Biology"}]
[null,8,"Brett",42,"Chemistry",null,{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS(G$11:$G12)),COLUMNS($A$1:A2))","v":5},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:H12)),COLUMNS($A$1:B2))","v":"David"},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:I12)),COLUMNS($A$1:C2))","v":87},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:J12)),COLUMNS($A$1:D2))","v":"Physics"}]
[null,9,"Adam",25,"Math",null,{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS(G$11:$G13)),COLUMNS($A$1:A3))","v":6},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:H13)),COLUMNS($A$1:B3))","v":"Chris"},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:I13)),COLUMNS($A$1:C3))","v":95},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:J13)),COLUMNS($A$1:D3))","v":"Physics"}]
[null,10,"Kevin",18,"Biology",null,{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS(G$11:$G14)),COLUMNS($A$1:A4))","v":7},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:H14)),COLUMNS($A$1:B4))","v":"Kane"},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:I14)),COLUMNS($A$1:C4))","v":100},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:J14)),COLUMNS($A$1:D4))","v":"Math"}]

{"sheet":"Protected","index":1,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,9],[7,6,7,9]]}
[]
[null,"Hide Formula in Extracting Data from Range by Array with VBA"]
[]
[null,"ID","Name","Marks","Department",null,null,"Start Value",80]
[null,1,"Joe",60,"Math",null,null,"End Value",100]
[null,2,"Josh",30,"Physics",null,null,"Column",3]
[null,3,"Johnny",80,"Biology"]
[null,4,"Mike",55,"Chemistry",null,"Search Result"]
[null,5,"David",87,"Physics"]
[null,6,"Chris",95,"Physics",null,"ID","Name","Marks","Department"]
[null,7,"Kane",100,"Math",null,{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS(G11:$G$11)),COLUMNS($A$1:A1))","v":3},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G11:H$11)),COLUMNS($A$1:B1))","v":"Johnny"},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G11:I$11)),COLUMNS($A$1:C1))","v":80},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G11:J$11)),COLUMNS($A$1:D1))","v":"Biology"}]
[null,8,"Brett",42,"Chemistry",null,{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS(G$11:$G12)),COLUMNS($A$1:A2))","v":5},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:H12)),COLUMNS($A$1:B2))","v":"David"},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:I12)),COLUMNS($A$1:C2))","v":87},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:J12)),COLUMNS($A$1:D2))","v":"Physics"}]
[null,9,"Adam",25,"Math",null,{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS(G$11:$G13)),COLUMNS($A$1:A3))","v":6},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:H13)),COLUMNS($A$1:B3))","v":"Chris"},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:I13)),COLUMNS($A$1:C3))","v":95},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:J13)),COLUMNS($A$1:D3))","v":"Physics"}]
[null,10,"Kevin",18,"Biology",null,{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS(G$11:$G14)),COLUMNS($A$1:A4))","v":7},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:H14)),COLUMNS($A$1:B4))","v":"Kane"},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:I14)),COLUMNS($A$1:C4))","v":100},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:J14)),COLUMNS($A$1:D4))","v":"Math"}]

{"sheet":"Hidden","index":2,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,9],[7,6,7,9]]}
[]
[null,"Hide Formula in Extracting Data from Range by Array with VBA"]
[]
[null,"ID","Name","Marks","Department",null,null,"Start Value",80]
[null,1,"Joe",60,"Math",null,null,"End Value",100]
[null,2,"Josh",30,"Physics",null,null,"Column",3]
[null,3,"Johnny",80,"Biology"]
[null,4,"Mike",55,"Chemistry",null,"Search Result"]
[null,5,"David",87,"Physics"]
[null,6,"Chris",95,"Physics",null,"ID","Name","Marks","Department"]
[null,7,"Kane",100,"Math",null,3,"Johnny",80,"Biology"]
[null,8,"Brett",42,"Chemistry",null,5,"David",87,"Physics"]
[null,9,"Adam",25,"Math",null,6,"Chris",95,"Physics"]
[null,10,"Kevin",18,"Biology",null,7,"Kane",100,"Math"]

{"sheet":"Prevent Deletion","index":3,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,9],[7,6,7,9]]}
[]
[null,"Hide Formula in Extracting Data from Range by Array with VBA"]
[]
[null,"ID","Name","Marks","Department",null,null,"Start Value",80]
[null,1,"Joe",60,"Math",null,null,"End Value",100]
[null,2,"Josh",30,"Physics",null,null,"Column",3]
[null,3,"Johnny",80,"Biology"]
[null,4,"Mike",55,"Chemistry",null,"Search Result"]
[null,5,"David",87,"Physics"]
[null,6,"Chris",95,"Physics",null,"ID","Name","Marks","Department"]
[null,7,"Kane",100,"Math",null,{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS(G11:$G$11)),COLUMNS($A$1:A1))","v":3},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G11:H$11)),COLUMNS($A$1:B1))","v":"Johnny"},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G11:I$11)),COLUMNS($A$1:C1))","v":80},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G11:J$11)),COLUMNS($A$1:D1))","v":"Biology"}]
[null,8,"Brett",42,"Chemistry",null,{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS(G$11:$G12)),COLUMNS($A$1:A2))","v":5},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:H12)),COLUMNS($A$1:B2))","v":"David"},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:I12)),COLUMNS($A$1:C2))","v":87},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:J12)),COLUMNS($A$1:D2))","v":"Physics"}]
[null,9,"Adam",25,"Math",null,{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS(G$11:$G13)),COLUMNS($A$1:A3))","v":6},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:H13)),COLUMNS($A$1:B3))","v":"Chris"},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:I13)),COLUMNS($A$1:C3))","v":95},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:J13)),COLUMNS($A$1:D3))","v":"Physics"}]
[null,10,"Kevin",18,"Biology",null,{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS(G$11:$G14)),COLUMNS($A$1:A4))","v":7},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:H14)),COLUMNS($A$1:B4))","v":"Kane"},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:I14)),COLUMNS($A$1:C4))","v":100},{"$f":"INDEX($B$5:$E$14,SMALL(IF((INDEX($B$5:$E$14,,$I$6)<=$I$5)*(INDEX($B$5:$E$14,,$I$6)>=$I$4),MATCH(ROW($B$5:$E$14),ROW($B$5:$E$14)),\"\"),ROWS($G$11:J14)),COLUMNS($A$1:D4))","v":"Math"}]