{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["ROW & ROWS","MIN,ROW & ROWS","INDEX, ROW & ROWS","MAX & ROW","MATCH &REPT","LOOKUP","SUMPRODUCT","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":"ROW & ROWS","index":0,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Use of ROW & ROWS Functions",null,null,null,null,"Practice Yourself"]
[]
[null,"Salesperson","Location",null,"Last Row",null,"Salesperson","Location",null,"Last Row"]
[null,"John","New York",null,{"$f":"ROW(B5:C15) + ROWS(B5:C15)-1","v":15},null,"John","New York"]
[null,"Chris","New Jersey",null,16,null,"Chris","New Jersey"]
[null,"Rosa","California",null,17,null,"Rosa","California"]
[null,"Patrick","Texas",null,18,null,"Patrick","Texas"]
[null,"Christina","New York",null,19,null,"Christina","New York"]
[null,"Tony","Los Angeles",null,20,null,"Tony","Los Angeles"]
[null,"Rachel","Boston ",null,21,null,"Rachel","Boston "]
[null,"Steve","Texas",null,22,null,"Steve","Texas"]
[null,"Evan","Akron",null,23,null,"Evan","Akron"]
[null,"Melinda","Washington",null,24,null,"Melinda","Washington"]
[null,"Emma","Boston",null,25,null,"Emma","Boston"]

{"sheet":"MIN,ROW & ROWS","index":1,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Use of MIN, ROW & ROWS Functions",null,null,null,null,"Practice Yourself"]
[]
[null,"Salesperson","Location",null,"Last Row",null,"Salesperson","Location",null,"Last Row"]
[null,"John","New York",null,{"$f":"MIN(ROW(B5:C15))+ROWS(B5:C15)-1","v":15},null,"John","New York"]
[null,"Chris","New Jersey",null,null,null,"Chris","New Jersey"]
[null,"Rosa","California",null,null,null,"Rosa","California"]
[null,"Patrick","Texas",null,null,null,"Patrick","Texas"]
[null,"Christina","New York",null,null,null,"Christina","New York"]
[null,"Tony","Los Angeles",null,null,null,"Tony","Los Angeles"]
[null,"Rachel","Boston ",null,null,null,"Rachel","Boston "]
[null,"Steve","Texas",null,null,null,"Steve","Texas"]
[null,"Evan","Akron",null,null,null,"Evan","Akron"]
[null,"Melinda","Washington",null,null,null,"Melinda","Washington"]
[null,"Emma","Boston",null,null,null,"Emma","Boston"]

{"sheet":"INDEX, ROW & ROWS","index":2,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Use of INDEX, ROW & ROWS Functions",null,null,null,null,"Practice Yourself"]
[]
[null,"Salesperson","Location",null,"Last Row",null,"Salesperson","Location",null,"Last Row"]
[null,"John","New York",null,{"$f":"ROW(INDEX(B5:C15,1,1))+ROWS(B5:C15)-1","v":15},null,"John","New York"]
[null,"Chris","New Jersey",null,null,null,"Chris","New Jersey"]
[null,"Rosa","California",null,null,null,"Rosa","California"]
[null,"Patrick","Texas",null,null,null,"Patrick","Texas"]
[null,"Christina","New York",null,null,null,"Christina","New York"]
[null,"Tony","Los Angeles",null,null,null,"Tony","Los Angeles"]
[null,"Rachel","Boston ",null,null,null,"Rachel","Boston "]
[null,"Steve","Texas",null,null,null,"Steve","Texas"]
[null,"Evan","Akron",null,null,null,"Evan","Akron"]
[null,"Melinda","Washington",null,null,null,"Melinda","Washington"]
[null,"Emma","Boston",null,null,null,"Emma","Boston"]

{"sheet":"MAX & ROW","index":3,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Use of MAX & ROW Functions",null,null,null,null,"Practice Yourself"]
[]
[null,"Salesperson","Location",null,"Last Row",null,"Salesperson","Location",null,"Last Row"]
[null,"John","New York",null,{"$f":"MAX((B:B<>\"\")*(ROW(B:B)))","v":14},null,"John","New York"]
[null,"Chris","New Jersey",null,null,null,"Chris","New Jersey"]
[null,"Rosa","California",null,null,null,"Rosa","California"]
[null,"Patrick","Texas",null,null,null,"Patrick","Texas"]
[null,"Christina","New York",null,null,null,"Christina","New York"]
[null,"Tony","Los Angeles",null,null,null,"Tony","Los Angeles"]
[null,"Rachel","Boston ",null,null,null,"Rachel","Boston "]
[null,"Steve","Texas",null,null,null,"Steve","Texas"]
[null,"Evan","Akron",null,null,null,"Evan","Akron"]
[null,"Melinda","Washington",null,null,null,"Melinda","Washington"]

{"sheet":"MATCH &REPT","index":4,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Use of MATCH & REPT Function",null,null,null,null,"Practice Yourself"]
[]
[null,"Salesperson","Location",null,"Last Row",null,"Salesperson","Location",null,"Last Row"]
[null,"John","New York",null,{"$f":"MATCH(REPT(\"z\",50),B:B)","v":14},null,"John","New York"]
[null,"Chris","New Jersey",null,null,null,"Chris","New Jersey"]
[null,"Rosa","California",null,null,null,"Rosa","California"]
[null,"Patrick","Texas",null,null,null,"Patrick","Texas"]
[null,"Christina","New York",null,null,null,"Christina","New York"]
[null,"Tony","Los Angeles",null,null,null,"Tony","Los Angeles"]
[null,"Rachel","Boston ",null,null,null,"Rachel","Boston "]
[null,"Steve","Texas",null,null,null,"Steve","Texas"]
[null,"Evan","Akron",null,null,null,"Evan","Akron"]
[null,"Melinda","Washington",null,null,null,"Melinda","Washington"]

{"sheet":"LOOKUP","index":5,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Use of LOOKUP Function",null,null,null,null,"Practice Yourself"]
[]
[null,"Salesperson","Location",null,"Last Row",null,"Salesperson","Location",null,"Last Row"]
[null,"John","New York",null,{"$f":"LOOKUP(2,1/(B:B<>\"\"),ROW(B:B))","v":14},null,"John","New York"]
[null,"Chris","New Jersey",null,null,null,"Chris","New Jersey"]
[null,"Rosa","California",null,null,null,"Rosa","California"]
[null,"Patrick","Texas",null,null,null,"Patrick","Texas"]
[null,"Christina","New York",null,null,null,"Christina","New York"]
[null,"Tony","Los Angeles",null,null,null,"Tony","Los Angeles"]
[null,"Rachel","Boston ",null,null,null,"Rachel","Boston "]
[null,"Steve","Texas",null,null,null,"Steve","Texas"]
[null,"Evan","Akron",null,null,null,"Evan","Akron"]
[null,"Melinda","Washington",null,null,null,"Melinda","Washington"]

{"sheet":"SUMPRODUCT","index":6,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Use of SUMPRODUCT Function",null,null,null,null,"Practice Yourself"]
[]
[null,"Salesperson","Location",null,"Last Row",null,"Salesperson","Location",null,"Last Row"]
[null,"John","New York",null,{"$f":"SUMPRODUCT(MAX((C5:C15<>\"\")*ROW(C5:C15)))","v":14},null,"John","New York"]
[null,"Chris","New Jersey",null,null,null,"Chris","New Jersey"]
[null,"Rosa","California",null,null,null,"Rosa","California"]
[null,"Patrick","Texas",null,null,null,"Patrick","Texas"]
[null,"Christina","New York",null,null,null,"Christina","New York"]
[null,"Tony","Los Angeles",null,null,null,"Tony","Los Angeles"]
[null,"Rachel","Boston ",null,null,null,"Rachel","Boston "]
[null,"Steve","Texas",null,null,null,"Steve","Texas"]
[null,"Evan","Akron",null,null,null,"Evan","Akron"]
[null,"Melinda","Washington",null,null,null,"Melinda","Washington"]

{"sheet":"VBA","index":7,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of VBA Code"]
[]
[null,"Salesperson","Location"]
[null,"John","New York"]
[null,"Chris","New Jersey"]
[null,"Rosa","California"]
[null,"Patrick","Texas"]
[null,"Christina","New York"]
[null,"Tony","Los Angeles"]
[null,"Rachel","Boston "]
[null,"Steve","Texas"]
[null,"Evan","Akron"]
[null,"Melinda","Washington"]