{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Dataset","search","countif","count search","isnumber","find","if and search","Match","combined","vba","diy"],"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":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Highlight Partial Text"]
[]
[null,"Name","ID No"]
[null,"Ben","00-12MN"]
[null,"Tom","00-08BV"]
[null,"Tony","01-03LP"]
[null,"Stark","20-09JN"]
[null,"Daniel","01-02AQ"]
[null,"Jacob","00-24BT"]
[null,"Frank","01-11QW"]
[null,"Isiah","00-13QX"]
[null,"Arthur","02-00PU"]

{"sheet":"search","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using SEARCH Function"]
[]
[null,"Name","ID No"]
[null,"Ben","00-12MN"]
[null,"Tom","00-08BV"]
[null,"Tony","01-03LP"]
[null,"Stark","20-09JN"]
[null,"Daniel","01-02AQ"]
[null,"Jacob","00-24BT"]
[null,"Frank","01-11QW"]
[null,"Isiah","00-13QX"]
[null,"Arthur","02-00PU"]

{"sheet":"countif","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using COUNTIF Function"]
[]
[null,"Name","ID No",null,"Starts with"]
[null,"Ben","00-12MN",null,"00-"]
[null,"Tom","00-08BV"]
[null,"Tony","01-03LP"]
[null,"Stark","20-09JN"]
[null,"Daniel","01-02AQ"]
[null,"Jacob","00-24BT"]
[null,"Frank","01-11QW"]
[null,"Isiah","00-13QX"]
[null,"Arthur","02-00PU"]

{"sheet":"count search","index":3,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"COUNT & SEARCH Function"]
[]
[null,"Name","ID No",null,"Starts with"]
[null,"Ben","00-12MN",null,"00-"]
[null,"Tom","00-08BV"]
[null,"Tony","01-03LP"]
[null,"Stark","20-09JN"]
[null,"Daniel","01-02AQ"]
[null,"Jacob","00-24BT"]
[null,"Frank","01-11QW"]
[null,"Isiah","00-13QX"]
[null,"Arthur","02-00PU"]

{"sheet":"isnumber","index":4,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"ISNUMBER & SEARCH Functions"]
[]
[null,"Name","ID No",null,"Starts with"]
[null,"Ben","00-12MN",null,"00-"]
[null,"Tom","00-08BV"]
[null,"Tony","01-03LP"]
[null,"Stark","20-09JN"]
[null,"Daniel","01-02AQ"]
[null,"Jacob","00-24BT"]
[null,"Frank","01-11QW"]
[null,"Isiah","00-13QX"]
[null,"Arthur","02-00PU"]

{"sheet":"find","index":5,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Highlight Partial Text"]
[]
[null,"Name","ID No"]
[null,"Ben","00-12MN"]
[null,"Tom","00-08BV"]
[null,"Tony","01-03LP"]
[null,"Stark","20-09JN"]
[null,"Daniel","01-02AQ"]
[null,"Jacob","00-24BT"]
[null,"Frank","01-11QW"]
[null,"Isiah","00-13QX"]
[null,"Arthur","02-00PU"]

{"sheet":"if and search","index":6,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Highlight Partial Text"]
[]
[null,"Name","ID No"]
[null,"Ben","00-12MN"]
[null,"Tom","00-08BV"]
[null,"Tony","01-03LP"]
[null,"Stark","20-09JN"]
[null,"Daniel","01-02AQ"]
[null,"Jacob","00-24BT"]
[null,"Frank","01-11QW"]
[null,"Isiah","00-13QX"]
[null,"Arthur","02-00PU"]

{"sheet":"Match","index":7,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using MATCH Function"]
[]
[null,"Name","ID No"]
[null,"Ben","00-12MN"]
[null,"Tom","00-08BV"]
[null,"Tony","01-03LP"]
[null,"Stark","20-09JN"]
[null,"Daniel","01-02AQ"]
[null,"Jacob","00-24BT"]
[null,"Frank","01-11QW"]
[null,"Isiah","00-13QX"]
[null,"Arthur","02-00PU"]

{"sheet":"combined","index":8,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Combined Formula"]
[]
[null,"Name","ID No"]
[null,"Ben","00-12MN"]
[null,"Tom","00-08BV"]
[null,"Tony","01-03LP"]
[null,"Stark","20-09JN"]
[null,"Daniel","01-02AQ"]
[null,"Jacob","00-24BT"]
[null,"Frank","01-11QW"]
[null,"Isiah","00-13QX",null,null,null,"dkdkf"]
[null,"Arthur","02-00PU",null,null,null,{"$f":"SEARCH(\"k\",G12)","v":2}]

{"sheet":"vba","index":9,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Highlight Partial Text"]
[]
[null,"Name","ID No"]
[null,"Ben","00-12MN"]
[null,"Tom","00-08BV"]
[null,"Tony","01-03LP"]
[null,"Stark","20-09JN"]
[null,"Daniel","01-02AQ"]
[null,"Jacob","00-24BT"]
[null,"Frank","01-11QW"]
[null,"Isiah","00-13QX"]
[null,"Arthur","02-00PU"]

{"sheet":"diy","index":10,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Do It Yourself"]
[]
[null,"Name","ID No"]
[null,"Ben","00-12MN"]
[null,"Tom","00-08BV"]
[null,"Tony","01-03LP"]
[null,"Stark","20-09JN"]
[null,"Daniel","01-02AQ"]
[null,"Jacob","00-24BT"]
[null,"Frank","01-11QW"]
[null,"Isiah","00-13QX"]
[null,"Arthur","02-00PU"]