{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","MAX & MIN Functions","MAX & MINIFS Functions","MAX, MIN & IF Functions","SMALL & LARGE Function","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sales of Shoes and Bags in 2022"]
[]
[null,"Store Number","Sales of Shoes","Sales of Bags"]
[null,"Store-1",4380,7654]
[null,"Store-2",2358,2456]
[null,"Store-3",7654,5000]
[null,"Store-4",2456,4060]
[null,"Store-5",5000,4380]
[null,"Store-6",4060,2358]
[null,"Store-7",5096,7654]
[null,"Store-8",10000,2456]
[null,"Store-9",11050,13000]
[null,"Store-10",5700,12500]
[null,"Store-11",3000,11000]

{"sheet":"MAX & MIN Functions","index":1,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using MAX and MIN Functions",null,null,null,null,null,"Do It Yourself"]
[]
[null,"Store Number","Sales of Shoes","Sales of Bags",null,null,null,"Store Number","Sales of Shoes","Sales of Bags"]
[null,"Store-1",4380,7654,null,null,null,"Store-1",4380,7654]
[null,"Store-2",2358,2456,null,null,null,"Store-2",2358,2456]
[null,"Store-3",7654,5000,null,null,null,"Store-3",7654,5000]
[null,"Store-4",2456,4060,null,null,null,"Store-4",2456,4060]
[null,"Store-5",5000,4380,null,null,null,"Store-5",5000,4380]
[null,"Store-6",4060,2358,null,null,null,"Store-6",4060,2358]
[null,"Store-7",5096,7654,null,null,null,"Store-7",5096,7654]
[null,"Store-8",10000,2456,null,null,null,"Store-8",10000,2456]
[null,"Store-9",11050,13000,null,null,null,"Store-9",11050,13000]
[null,"Store-10",5700,12500,null,null,null,"Store-10",5700,12500]
[null,"Store-11",3000,11000,null,null,null,"Store-11",3000,11000]
[null,"Range",{"$f":"MAX(C5:C15)-MIN(C5:C15)","v":8692},{"$f":"MAX(D5:D15)-MIN(D5:D15)","v":10642},null,null,null,"Range"]

{"sheet":"MAX & MINIFS Functions","index":2,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Using MAX and MINIFS Functions",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Store Number","Sales of Shoes","Sales of Bags",null,null,null,null,"Store Number","Sales of Shoes","Sales of Bags"]
[null,"Store-1",4380,7654,null,null,null,null,"Store-1",4380,7654]
[null,"Store-2",500,2456,null,null,null,null,"Store-2",2358,2456]
[null,"Store-3",7654,100,null,null,null,null,"Store-3",7654,5000]
[null,"Store-4",2456,4060,null,null,null,null,"Store-4",2456,4060]
[null,"Store-5",5000,4380,null,null,null,null,"Store-5",5000,4380]
[null,"Store-6",4060,2358,null,null,null,null,"Store-6",4060,2358]
[null,"Store-7",200,7654,null,null,null,null,"Store-7",5096,7654]
[null,"Store-8",10000,150,null,null,null,null,"Store-8",10000,2456]
[null,"Store-9",11050,13000,null,null,null,null,"Store-9",11050,13000]
[null,"Store-10",5700,12500,null,null,null,null,"Store-10",5700,12500]
[null,"Store-11",3000,11000,null,null,null,null,"Store-11",3000,11000]
[null,"Conditional Range",{"$f":"MAX(C5:C15)-_xlfn.MINIFS(C5:C15,C5:C15,\">1000\")","v":8594},{"$f":"MAX(D5:D15)-_xlfn.MINIFS(D5:D15,D5:D15,\">1000\")","v":10642},null,null,null,null,"Range"]

{"sheet":"MAX, MIN & IF Functions","index":3,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Using MAX, MIN and IF Functions",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Store Number","Sales of Shoes","Sales of Bags",null,null,null,null,"Store Number","Sales of Shoes","Sales of Bags"]
[null,"Store-1",4380,7654,null,null,null,null,"Store-1",4380,7654]
[null,"Store-2",500,2456,null,null,null,null,"Store-2",2358,2456]
[null,"Store-3",7654,100,null,null,null,null,"Store-3",7654,5000]
[null,"Store-4",2456,4060,null,null,null,null,"Store-4",2456,4060]
[null,"Store-5",5000,4380,null,null,null,null,"Store-5",5000,4380]
[null,"Store-6",4060,2358,null,null,null,null,"Store-6",4060,2358]
[null,"Store-7",200,7654,null,null,null,null,"Store-7",5096,7654]
[null,"Store-8",10000,150,null,null,null,null,"Store-8",10000,2456]
[null,"Store-9",11050,13000,null,null,null,null,"Store-9",11050,13000]
[null,"Store-10",5700,12500,null,null,null,null,"Store-10",5700,12500]
[null,"Store-11",3000,11000,null,null,null,null,"Store-11",3000,11000]
[null,"Conditional Range",{"$f":"MAX(C5:C15)-MIN(IF(C5:C15>3000,C5:C15))","v":6990},{"$f":"MAX(D5:D15)-MIN(IF(D5:D15>3000,D5:D15))","v":8940},null,null,null,null,"Range"]

{"sheet":"SMALL & LARGE Function","index":4,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Applying SMALL and LARGE Functions",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Store Number","Sales of Shoes","Sales of Bags",null,null,null,null,"Store Number","Sales of Shoes","Sales of Bags"]
[null,"Store-1",4380,7654,null,null,null,null,"Store-1",4380,7654]
[null,"Store-2",2358,2456,null,null,null,null,"Store-2",2358,2456]
[null,"Store-3",7654,5000,null,null,null,null,"Store-3",7654,5000]
[null,"Store-4",2456,4060,null,null,null,null,"Store-4",2456,4060]
[null,"Store-5",5000,4380,null,null,null,null,"Store-5",5000,4380]
[null,"Store-6",4060,2358,null,null,null,null,"Store-6",4060,2358]
[null,"Store-7",5096,7654,null,null,null,null,"Store-7",5096,7654]
[null,"Store-8",10000,2456,null,null,null,null,"Store-8",10000,2456]
[null,"Store-9",11050,13000,null,null,null,null,"Store-9",11050,13000]
[null,"Store-10",5700,12500,null,null,null,null,"Store-10",5700,12500]
[null,"Store-11",3000,11000,null,null,null,null,"Store-11",3000,11000]
[null,"Range",{"$f":"LARGE(C5:C15,1)-SMALL(C5:C15,1)","v":8692},{"$f":"LARGE(D5:D15,1)-SMALL(D5:D15,1)","v":10642},null,null,null,null,"Range"]

{"sheet":"VBA","index":5,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Utilizing VBA",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Store Number","Sales of Shoes","Sales of Bags",null,null,null,null,"Store Number","Sales of Shoes","Sales of Bags"]
[null,"Store-1",4380,7654,null,null,null,null,"Store-1",4380,7654]
[null,"Store-2",2358,2456,null,null,null,null,"Store-2",2358,2456]
[null,"Store-3",7654,5000,null,null,null,null,"Store-3",7654,5000]
[null,"Store-4",2456,4060,null,null,null,null,"Store-4",2456,4060]
[null,"Store-5",5000,4380,null,null,null,null,"Store-5",5000,4380]
[null,"Store-6",4060,2358,null,null,null,null,"Store-6",4060,2358]
[null,"Store-7",5096,7654,null,null,null,null,"Store-7",5096,7654]
[null,"Store-8",10000,2456,null,null,null,null,"Store-8",10000,2456]
[null,"Store-9",11050,13000,null,null,null,null,"Store-9",11050,13000]
[null,"Store-10",5700,12500,null,null,null,null,"Store-10",5700,12500]
[null,"Store-11",3000,11000,null,null,null,null,"Store-11",3000,11000]
[null,"Range",{"$f":"RangeS(Sales_Shoes)","v":8692},{"$f":"RangeB(Sales_Bags)","v":10642},null,null,null,null,"Range"]