{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Sample Datasheet","MIN, ROW and ROWS Function","ROW INDEX and ROWS Function","MATCH REPT Function","MAX Function","SUMPRODUCT Function","LOOKUP Function","VBA Code"],"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":"Sample Datasheet","index":0,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Finding Last Row Number with Data"]
[]
[null,"Year","FIFA World Cup Champions"]
[null,1986,"Argentina"]
[null,1990,"Germany"]
[null,1994,"Brazil"]
[null,1998,"France"]
[null,2002,"Brazil"]
[null,2006,"Italy"]
[null,2010,"Spain"]
[null,2014,"Germany"]
[null,2018,"France"]
[null,2022,"Argentina",null,null,null,null," "]

{"sheet":"MIN, ROW and ROWS Function","index":1,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,7,2,10]]}
[]
[]
[null,"Finding Last Row Number with Data",null,null,null,null,null,"For Practice"]
[]
[null,"Year","FIFA World Cup Champions",null,"Last Row Number",null,null,"Year","FIFA World Cup Champions",null,"Last Row Number"]
[null,1986,"Argentina",null,{"$f":"MIN(ROW(B6:C15))+ROWS(B6:C15)-1","v":15},null,null,1986,"Argentina"]
[null,1990,"Germany",null,null,null,null,1990,"Germany"]
[null,1994,"Brazil",null,null,null,null,1994,"Brazil"]
[null,1998,"France",null,null,null,null,1998,"France"]
[null,2002,"Brazil",null,null,null,null,2002,"Brazil"]
[null,2006,"Italy",null,null,null,null,2006,"Italy"]
[null,2010,"Spain",null,null,null,null,2010,"Spain"]
[null,2014,"Germany",null,null,null,null,2014,"Germany"]
[null,2018,"France",null,null,null,null,2018,"France"]
[null,2022,"Argentina",null,null,null,null,2022,"Argentina"]

{"sheet":"ROW INDEX and ROWS Function","index":2,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,7,2,10]]}
[]
[]
[null,"Finding Last Row Number with Data",null,null,null,null,null,"For Practice"]
[]
[null,"Year","FIFA World Cup Champions",null,"Last Row Number",null,null,"Year","FIFA World Cup Champions",null,"Last Row Number"]
[null,1986,"Argentina",null,{"$f":"ROW(INDEX(B6:C15,1,1))+ROWS(B6:C15)-1","v":15},null,null,1986,"Argentina"]
[null,1990,"Germany",null,null,null,null,1990,"Germany"]
[null,1994,"Brazil",null,null,null,null,1994,"Brazil"]
[null,1998,"France",null,null,null,null,1998,"France"]
[null,2002,"Brazil",null,null,null,null,2002,"Brazil"]
[null,2006,"Italy",null,null,null,null,2006,"Italy"]
[null,2010,"Spain",null,null,null,null,2010,"Spain"]
[null,2014,"Germany",null,null,null,null,2014,"Germany"]
[null,2018,"France",null,null,null,null,2018,"France"]
[null,2022,"Argentina",null,null,null,null,2022,"Argentina"]

{"sheet":"MATCH REPT Function","index":3,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,7,2,10]]}
[]
[]
[null,"Finding Last Row Number with Data",null,null,null,null,null,"For Practice"]
[]
[null,"Year","FIFA World Cup Champions",null,"Last Row Number",null,null,"Year","FIFA World Cup Champions",null,"Last Row Number"]
[null,1986,"Argentina",null,{"$f":"MATCH(REPT(\"z\",50),C:C)","v":15},null,null,1986,"Argentina"]
[null,1990,"Germany",null,null,null,null,1990,"Germany"]
[null,1994,"Brazil",null,null,null,null,1994,"Brazil"]
[null,1998,"France",null,null,null,null,1998,"France"]
[null,2002,"Brazil",null,null,null,null,2002,"Brazil"]
[null,2006,"Italy",null,null,null,null,2006,"Italy"]
[null,2010,"Spain",null,null,null,null,2010,"Spain"]
[null,2014,"Germany",null,null,null,null,2014,"Germany"]
[null,2018,"France",null,null,null,null,2018,"France"]
[null,2022,"Argentina",null,null,null,null,2022,"Argentina"]

{"sheet":"MAX Function","index":4,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,7,2,10]]}
[]
[]
[null,"Finding Last Row Number with Data",null,null,null,null,null,"For Practice"]
[]
[null,"Year","FIFA World Cup Champions",null,"Last Row Number",null,null,"Year","FIFA World Cup Champions",null,"Last Row Number"]
[null,1986,"Argentina",null,{"$f":"MAX((B:B<>\"\")*(ROW(B:B)))","v":15},null,null,1986,"Argentina"]
[null,1990,"Germany",null,null,null,null,1990,"Germany"]
[null,1994,"Brazil",null,null,null,null,1994,"Brazil"]
[null,1998,"France",null,null,null,null,1998,"France"]
[null,2002,"Brazil",null,null,null,null,2002,"Brazil"]
[null,2006,"Italy",null,null,null,null,2006,"Italy"]
[null,2010,"Spain",null,null,null,null,2010,"Spain"]
[null,2014,"Germany",null,null,null,null,2014,"Germany"]
[null,2018,"France",null,null,null,null,2018,"France"]
[null,2022,"Argentina",null,null,null,null,2022,"Argentina"]

{"sheet":"SUMPRODUCT Function","index":5,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,7,2,10]]}
[]
[]
[null,"Finding Last Row Number with Data",null,null,null,null,null,"For Practice"]
[]
[null,"Year","FIFA World Cup Champions",null,"Last Row Number",null,null,"Year","FIFA World Cup Champions",null,"Last Row Number"]
[null,1986,"Argentina",null,{"$f":"SUMPRODUCT(MAX((C5:C16<>\"\")*ROW(C5:C16)))","v":15},null,null,1986,"Argentina"]
[null,1990,"Germany",null,null,null,null,1990,"Germany"]
[null,1994,"Brazil",null,null,null,null,1994,"Brazil"]
[null,1998,"France",null,null,null,null,1998,"France"]
[null,2002,"Brazil",null,null,null,null,2002,"Brazil"]
[null,2006,"Italy",null,null,null,null,2006,"Italy"]
[null,2010,"Spain",null,null,null,null,2010,"Spain"]
[null,2014,"Germany",null,null,null,null,2014,"Germany"]
[null,2018,"France",null,null,null,null,2018,"France"]
[null,2022,"Argentina",null,null,null,null,2022,"Argentina"]

{"sheet":"LOOKUP Function","index":6,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,7,2,10]]}
[]
[]
[null,"Finding Last Row Number with Data",null,null,null,null,null,"For Practice"]
[]
[null,"Year","FIFA World Cup Champions",null,"Last Row Number",null,null,"Year","FIFA World Cup Champions",null,"Last Row Number"]
[null,1986,"Argentina",null,{"$f":"LOOKUP(2,1/(B:B<>\"\"),ROW(B:B))","v":15},null,null,1986,"Argentina"]
[null,1990,"Germany",null,null,null,null,1990,"Germany"]
[null,1994,"Brazil",null,null,null,null,1994,"Brazil"]
[null,1998,"France",null,null,null,null,1998,"France"]
[null,2002,"Brazil",null,null,null,null,2002,"Brazil"]
[null,2006,"Italy",null,null,null,null,2006,"Italy"]
[null,2010,"Spain",null,null,null,null,2010,"Spain"]
[null,2014,"Germany",null,null,null,null,2014,"Germany"]
[null,2018,"France",null,null,null,null,2018,"France"]
[null,2022,"Argentina",null,null,null,null,2022,"Argentina"]

{"sheet":"VBA Code","index":7,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,6,2,7]]}
[]
[]
[null,"Finding Last Row Number with Data",null,null,null,null,"For Practice"]
[]
[null,"Year","FIFA World Cup Champions",null,null,null,"Year","FIFA World Cup Champions"]
[null,1986,"Argentina",null,null,null,1986,"Argentina"]
[null,1990,"Germany",null,null,null,1990,"Germany"]
[null,1994,"Brazil",null,null,null,1994,"Brazil"]
[null,1998,"France",null,null,null,1998,"France"]
[null,2002,"Brazil",null,null,null,2002,"Brazil"]
[null,2006,"Italy",null,null,null,2006,"Italy"]
[null,2010,"Spain",null,null,null,2010,"Spain"]
[null,2014,"Germany",null,null,null,2014,"Germany"]
[null,2018,"France",null,null,null,2018,"France"]
[null,2022,"Argentina",null,null,null,2022,"Argentina"]