{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Overview","Rows","Columns","Entire Data","Non-adjacent Columns","Recent Date","Criteria","VBA","Quick Notes"],"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":"Overview","index":0,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Overview of Using Excel MAX Function"]
[]
[null,"Name","Quiz 1","Quiz 2","Quiz 3",null,"Method","Output"]
[null,"Angela",45,60,59,null,"Finding MAX value in a row\n=MAX(C5:E5)","Maximum value"]
[null,"Lora",70,59,77,null,"Finding MAX value in a column\n=MAX(C5:C10)","Maximum value"]
[null,"Mosses",33,87,66,null,"Finding highest value for entire data\n=MAX(C5:E10)",98]
[null,"John",80,70,81,null,"Finding highest value for non-adjacent columns\n=MAX(C5:C10,E5:E10)",12]
[null,"Adam",85,94,98,null,"Finding recent date\n=MAX(D5:D10)","2021-08-17"]
[null,"Ivy",66,78,80,null,"MAX Function with Criteria\n=MAX(IF(C5:C13=G5,D5:D13))",10]

{"sheet":"Rows","index":1,"n_rows":10,"n_cols":18,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,12,1,17]]}
[]
[null,"Use of MAX Function for Rows",null,null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Name","Quiz 1","Quiz 2","Quiz 3",null,"Highest Score",null,null,null,null,null,"Name","Quiz 1","Quiz 2","Quiz 3",null,"Highest Score"]
[null,"Angela",45,60,59,null,{"$f":"MAX(C5:E5)","v":60},null,null,null,null,null,"Angela",45,60,59]
[null,"Lora",70,59,77,null,{"$f":"MAX(C6:E6)","v":77},null,null,null,null,null,"Lora",70,59,77]
[null,"Mosses",33,87,66,null,87,null,null,null,null,null,"Mosses",33,87,66]
[null,"John",80,70,81,null,81,null,null,null,null,null,"John",80,70,81]
[null,"Adam",85,94,98,null,98,null,null,null,null,null,"Adam",85,94,98]
[null,"Ivy",66,78,80,null,80,null,null,null,null,null,"Ivy",66,78,80]

{"sheet":"Columns","index":2,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Use of MAX Function for Columns",null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Name","Quiz 1","Quiz 2","Quiz 3",null,null,null,null,null,null,"Name","Quiz 1","Quiz 2","Quiz 3"]
[null,"Angela",45,60,59,null,null,null,null,null,null,"Angela",45,60,59]
[null,"Lora",70,59,77,null,null,null,null,null,null,"Lora",70,59,77]
[null,"Mosses",33,87,66,null,null,null,null,null,null,"Mosses",33,87,66]
[null,"John",80,70,81,null,null,null,null,null,null,"John",80,70,81]
[null,"Adam",85,94,98,null,null,null,null,null,null,"Adam",85,94,98]
[null,"Ivy",66,78,80,null,null,null,null,null,null,"Ivy",66,78,80]
[]
[null,"Highest Per Quiz",{"$f":"MAX(C5:C10)","v":85},{"$f":"MAX(D5:D10)","v":94},98,null,null,null,null,null,null,"Highest Per Quiz"]

{"sheet":"Entire Data","index":3,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Performance of MAX Function for Entire Data",null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Name","Quiz 1","Quiz 2","Quiz 3",null,null,null,null,null,null,"Name","Quiz 1","Quiz 2","Quiz 3"]
[null,"Angela",45,60,59,null,null,null,null,null,null,"Angela",45,60,59]
[null,"Lora",70,59,77,null,null,null,null,null,null,"Lora",70,59,77]
[null,"Mosses",33,87,66,null,null,null,null,null,null,"Mosses",33,87,66]
[null,"John",80,70,81,null,null,null,null,null,null,"John",80,70,81]
[null,"Adam",85,94,98,null,null,null,null,null,null,"Adam",85,94,98]
[null,"Ivy",66,78,80,null,null,null,null,null,null,"Ivy",66,78,80]
[]
[null,null,"Max Value",{"$f":"MAX(C5:E10)","v":98},null,null,null,null,null,null,null,null,"Max Value"]

{"sheet":"Non-adjacent Columns","index":4,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Use of MAX Function for Non-adjacent Columns",null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Item","Shop 1","Shop 2","Shop 3",null,null,null,null,null,null,"Item","Shop 1","Shop 2","Shop 3"]
[null,"Apples",5,6,8,null,null,null,null,null,null,"Apples",5,6,8]
[null,"Bananas",7,9,9,null,null,null,null,null,null,"Bananas",7,9,9]
[null,"Oranges",8,6,10,null,null,null,null,null,null,"Oranges",8,6,10]
[null,"Watermelons",10,10,8,null,null,null,null,null,null,"Watermelons",10,10,8]
[null,"Mangoes",8,10,8,null,null,null,null,null,null,"Mangoes",8,10,8]
[null,"Strawberries",8,15,12,null,null,null,null,null,null,"Strawberries",8,15,12]
[]
[null,null,"Max Value",{"$f":"MAX(C5:C10,E5:E10)","v":12},null,null,null,null,null,null,null,null,"Max Value"]

{"sheet":"Recent Date","index":5,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Use of MAX Function for Recent Date",null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Shop Name","Item","Delivery Date",null,null,null,null,null,null,null,"Shop Name","Item","Delivery Date"]
[null,"Shop 1","Apples","2021-07-31",null,null,null,null,null,null,null,"Shop 1","Apples","2021-07-31"]
[null,"Shop 1","Bananas","2021-08-07",null,null,null,null,null,null,null,"Shop 1","Bananas","2021-08-07"]
[null,"Shop 1","Oranges","2021-08-08",null,null,null,null,null,null,null,"Shop 1","Oranges","2021-08-08"]
[null,"Shop 2","Apples","2021-08-17",null,null,null,null,null,null,null,"Shop 2","Apples","2021-08-17"]
[null,"Shop 2","Bananas","2021-08-16",null,null,null,null,null,null,null,"Shop 2","Bananas","2021-08-16"]
[null,"Shop 2","Oranges","2021-08-01",null,null,null,null,null,null,null,"Shop 2","Oranges","2021-08-01"]
[]
[null,null,"Recent Date",{"$f":"MAX(D5:D10)","v":"2021-08-17"},null,null,null,null,null,null,null,null,"Recent Date"]

{"sheet":"Criteria","index":6,"n_rows":13,"n_cols":19,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,14,1,19]]}
[]
[null,"Use of MAX Function with Criteria",null,null,null,null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Club Name","Item","Quantity",null,null,null,null,null,null,null,null,null,null,"Club Name","Item","Quantity"]
[null,"Club 1","Cricket Bats",8,null,"Item","Cricket Balls",null,null,null,null,null,null,null,"Club 1","Cricket Bats",8,null,"Item"]
[null,"Club 1","Cricket Balls",40,null,"Max",{"$f":"MAX(IF(C5:C13=G5,D5:D13))","v":40},null,null,null,null,null,null,null,"Club 1","Cricket Balls",40,null,"Max"]
[null,"Club 1","Gloves",6,null,null,null,null,null,null,null,null,null,null,"Club 1","Gloves",6]
[null,"Club 1","Helmets",8,null,null,null,null,null,null,null,null,null,null,"Club 1","Helmets",8]
[null,"Club 1","Footballs",10,null,null,null,null,null,null,null,null,null,null,"Club 1","Footballs",10]
[null,"Club 2","Cricket Bats",10,null,null,null,null,null,null,null,null,null,null,"Club 2","Cricket Bats",10]
[null,"Club 2","Cricket Balls",30,null,null,null,null,null,null,null,null,null,null,"Club 2","Cricket Balls",30]
[null,"Club 2","Gloves",10,null,null,null,null,null,null,null,null,null,null,"Club 2","Gloves",10]
[null,"Club 2","Helmets",10,null,null,null,null,null,null,null,null,null,null,"Club 2","Helmets",10]

{"sheet":"VBA","index":7,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,12,1,15]]}
[]
[null,"Use of VBA MAX Function",null,null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Name","Quiz 1","Quiz 2","Quiz 3",null,null,null,null,null,null,null,"Name","Quiz 1","Quiz 2","Quiz 3"]
[null,"Angela",45,60,59,null,null,null,null,null,null,null,"Angela",45,60,59]
[null,"Lora",70,59,77,null,null,null,null,null,null,null,"Lora",70,59,77]
[null,"Mosses",33,87,66,null,null,null,null,null,null,null,"Mosses",33,87,66]
[null,"John",80,70,81,null,null,null,null,null,null,null,"John",80,70,81]
[null,"Adam",85,94,98,null,null,null,null,null,null,null,"Adam",85,94,98]
[null,"Ivy",66,78,80,null,null,null,null,null,null,null,"Ivy",66,78,80]
[]
[null,"Max Value",98,null,null,null,null,null,null,null,null,null,"Max Value"]

{"sheet":"Quick Notes","index":8,"n_rows":13,"n_cols":19,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,14,1,19]]}
[]
[null,25,null,{"$f":"MAX(B2:B6)","v":66},null,null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[null,true]
[null,"Adam",null,null,null,null,null,null,null,null,null,null,null,null,"Club Name","Item","Quantity"]
[null,66,null,null,null,null,null,null,null,null,null,null,null,null,"Club 1","Cricket Bats",8,null,"Item"]
[null,6,null,null,null,null,null,null,null,null,null,null,null,null,"Club 1","Cricket Balls",40,null,"Max"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Club 1","Gloves",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Club 1","Helmets",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Club 1","Footballs",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Club 2","Cricket Bats",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Club 2","Cricket Balls",30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Club 2","Gloves",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Club 2","Helmets",10]