{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","ROW","MATCH","MATCH & ROW","INDEX, MATCH & ROW","SMALL & MATCH","One CELL","VBA"],"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":"Dataset","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,9]]}
[]
[null,"Dataset"]
[]
[null,"Name","Country"]
[null,"John","United States"]
[null,"Chris","Canada"]
[null,"Lisa","United Kingdom"]
[null,"Richard","United States"]
[null,"Jessica","Mexico"]
[null,"Tony","United States"]

{"sheet":"ROW","index":1,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Use of ROW Function",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Country",null,"Name","Row Number",null,null,"Name","Country",null,"Name","Row Number"]
[null,"John","United States",null,"Chris",{"$f":"ROW(C6)","v":6},null,null,"John","United States",null,"Chris"]
[null,"Chris","Canada",null,null,null,null,null,"Chris","Canada"]
[null,"Lisa","United Kingdom",null,null,null,null,null,"Lisa","United Kingdom"]
[null,"Richard","United States",null,null,null,null,null,"Richard","United States"]
[null,"Jessica","Mexico",null,null,null,null,null,"Jessica","Mexico"]
[null,"Tony","United States",null,null,null,null,null,"Tony","United States"]

{"sheet":"MATCH","index":2,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Use of MATCH Function",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Country",null,"Country","Row Number",null,null,"Name","Country",null,"Country","Row Number"]
[null,"John","United States",null,"Canada",{"$f":"MATCH(E5,C:C,0)","v":6},null,null,"John","United States",null,"Canada"]
[null,"Chris","Canada",null,null,null,null,null,"Chris","Canada"]
[null,"Lisa","United Kingdom",null,null,null,null,null,"Lisa","United Kingdom"]
[null,"Richard","United States",null,null,null,null,null,"Richard","United States"]
[null,"Jessica","Mexico",null,null,null,null,null,"Jessica","Mexico"]
[null,"Tony","United States",null,null,null,null,null,"Tony","United States"]

{"sheet":"MATCH & ROW","index":3,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Combination of MATCH & ROW Functions ",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Country",null,"Country","Row Number",null,null,"Name","Country",null,"Country","Row Number"]
[null,"John","United States",null,"Canada",{"$f":"MATCH(E5,C5:C10,0)+ROW(C5:C10)-1","v":6},null,null,"John","United States",null,"Canada"]
[null,"Chris","Canada",null,null,7,null,null,"Chris","Canada"]
[null,"Lisa","United Kingdom",null,null,8,null,null,"Lisa","United Kingdom"]
[null,"Richard","United States",null,null,9,null,null,"Richard","United States"]
[null,"Jessica","Mexico",null,null,10,null,null,"Jessica","Mexico"]
[null,"Tony","United States",null,null,11,null,null,"Tony","United States"]

{"sheet":"INDEX, MATCH & ROW","index":4,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Combination of INDEX, MATCH, & ROW Functions",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Country",null,"Country","Row Number",null,null,"Name","Country",null,"Country","Row Number"]
[null,"John","United States",null,"Canada",{"$f":"ROW(INDEX(B4:B10,MATCH(E5,C4:C10,0)))","v":6},null,null,"John","United States",null,"Canada"]
[null,"Chris","Canada",null,null,null,null,null,"Chris","Canada"]
[null,"Lisa","United Kingdom",null,null,null,null,null,"Lisa","United Kingdom"]
[null,"Richard","United States",null,null,null,null,null,"Richard","United States"]
[null,"Jessica","Mexico",null,null,null,null,null,"Jessica","Mexico"]
[null,"Tony","United States",null,null,null,null,null,"Tony","United States"]

{"sheet":"SMALL & MATCH","index":5,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Combination of SMALL & MATCH Functions",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Country","Area",null,"Lowest Area",null,null,"Name","Country",null,"Lowest Area"]
[null,"United States",9833517,null,{"$f":"MATCH(SMALL(C5:C10,1),C5:C10)","v":3},null,null,"John","United States"]
[null,"Canada",9984670,null,null,null,null,"Chris","Canada"]
[null,"United Kingdom",243610,null,null,null,null,"Lisa","United Kingdom"]
[null,"Australia ",7741220,null,null,null,null,"Richard","United States"]
[null,"Mexico",1964375,null,null,null,null,"Jessica","Mexico"]
[null,"Brazil",8515770,null,null,null,null,"Tony","United States"]

{"sheet":"One CELL","index":6,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Return Matching Rows in One Cell",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Name","Country",null,"Country","Row Number",null,null,"Name","Country",null,"Country","Row Number"]
[null,"John","United States",null,"United States",{"$f":"_xlfn.TEXTJOIN(\",\",,IF(C5:C10=E5,ROW(C5:C10),\"\"))","v":"5,8,10"},null,null,"John","United States",null,"United States"]
[null,"Chris","Canada",null,null,null,null,null,"Chris","Canada"]
[null,"Lisa","United Kingdom",null,null,null,null,null,"Lisa","United Kingdom"]
[null,"Richard","United States",null,null,null,null,null,"Richard","United States"]
[null,"Jessica","Mexico",null,null,null,null,null,"Jessica","Mexico"]
[null,"Tony","United States",null,null,null,null,null,"Tony","United States"]

{"sheet":"VBA","index":7,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of VBA Code"]
[]
[null,"Name","Country"]
[null,"John","United States"]
[null,"Chris","Canada"]
[null,"Lisa","United Kingdom"]
[null,"Richard","United States"]
[null,"Jessica","Mexico"]
[null,"Tony","United States"]