{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Array Formula","LARGE & COUNTIF","SMALL & COUNTIFS","AGGREGATE","Excel 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":"Array Formula","index":0,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14],[10,1,10,2]]}
[]
[null,"Utilizing Array Formula",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Account Title","Sales","Salesperson",null,null,null,null,null,null,null,null,"Account Title","Sales","Salesperson"]
[null,"Advertising",33,"Andy Teal",null,null,null,null,null,null,null,null,"Advertising",33,"Andy Teal"]
[null,"Printers",70,"Robert Walters",null,null,null,null,null,null,null,null,"Printers",70,"Robert Walters"]
[null,"Client Expenses",19,"Susan W. Eaton",null,null,null,null,null,null,null,null,"Client Expenses",19,"Susan W. Eaton"]
[null,"Computers",0,"Kim Ralls",null,null,null,null,null,null,null,null,"Computers",0,"Kim Ralls"]
[null,"Medical Plan",8,"Kathie Flood",null,null,null,null,null,null,null,null,"Medical Plan",8,"Kathie Flood"]
[]
[null,"Minimum Value Greater than 0",null,{"$f":"MIN(IF(C5:C9>0,C5:C9))","v":8}]

{"sheet":"LARGE & COUNTIF","index":1,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14],[10,1,10,2]]}
[]
[null,"Combination of LARGE and COUNTIF Functions",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Account Title","Sales","Salesperson",null,null,null,null,null,null,null,null,"Account Title","Sales","Salesperson"]
[null,"Advertising",33,"Andy Teal",null,null,null,null,null,null,null,null,"Advertising",33,"Andy Teal"]
[null,"Printers",70,"Robert Walters",null,null,null,null,null,null,null,null,"Printers",70,"Robert Walters"]
[null,"Client Expenses",19,"Susan W. Eaton",null,null,null,null,null,null,null,null,"Client Expenses",19,"Susan W. Eaton"]
[null,"Computers",0,"Kim Ralls",null,null,null,null,null,null,null,null,"Computers",0,"Kim Ralls"]
[null,"Medical Plan",8,"Kathie Flood",null,null,null,null,null,null,null,null,"Medical Plan",8,"Kathie Flood"]
[]
[null,"Minimum Value Greater than 0",null,{"$f":"LARGE(C5:C9,COUNTIF(C5:C9,\">0\"))","v":8}]

{"sheet":"SMALL & COUNTIFS","index":2,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14],[10,1,10,2]]}
[]
[null,"Joining SMALL and COUNTIFS Functions",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Account Title","Sales","Salesperson",null,null,null,null,null,null,null,null,"Account Title","Sales","Salesperson"]
[null,"Advertising",33,"Andy Teal",null,null,null,null,null,null,null,null,"Advertising",33,"Andy Teal"]
[null,"Printers",70,"Robert Walters",null,null,null,null,null,null,null,null,"Printers",70,"Robert Walters"]
[null,"Client Expenses",19,"Susan W. Eaton",null,null,null,null,null,null,null,null,"Client Expenses",19,"Susan W. Eaton"]
[null,"Computers",0,"Kim Ralls",null,null,null,null,null,null,null,null,"Computers",0,"Kim Ralls"]
[null,"Medical Plan",8,"Kathie Flood",null,null,null,null,null,null,null,null,"Medical Plan",8,"Kathie Flood"]
[]
[null,"Minimum Value Greater than 0",null,{"$f":"SMALL(C5:C9,COUNTIFS(C5:C9,0)+1)","v":8}]

{"sheet":"AGGREGATE","index":3,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14],[10,1,10,2]]}
[]
[null,"Use of AGGREGATE Function",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Account Title","Sales","Salesperson",null,null,null,null,null,null,null,null,"Account Title","Sales","Salesperson"]
[null,"Advertising",33,"Andy Teal",null,null,null,null,null,null,null,null,"Advertising",33,"Andy Teal"]
[null,"Printers",70,"Robert Walters",null,null,null,null,null,null,null,null,"Printers",70,"Robert Walters"]
[null,"Client Expenses",19,"Susan W. Eaton",null,null,null,null,null,null,null,null,"Client Expenses",19,"Susan W. Eaton"]
[null,"Computers",0,"Kim Ralls",null,null,null,null,null,null,null,null,"Computers",0,"Kim Ralls"]
[null,"Medical Plan",8,"Kathie Flood",null,null,null,null,null,null,null,null,"Medical Plan",8,"Kathie Flood"]
[]
[null,"Minimum Value Greater than 0",null,{"$f":"1/_xlfn.AGGREGATE(14,6,1/C5:C9,1)","v":8}]

{"sheet":"Excel VBA","index":4,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14],[10,1,10,2]]}
[]
[null,"Running a VBA Code in Excel",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Account Title","Sales","Salesperson",null,null,null,null,null,null,null,null,"Account Title","Sales","Salesperson"]
[null,"Advertising",33,"Andy Teal",null,null,null,null,null,null,null,null,"Advertising",33,"Andy Teal"]
[null,"Printers",70,"Robert Walters",null,null,null,null,null,null,null,null,"Printers",70,"Robert Walters"]
[null,"Client Expenses",19,"Susan W. Eaton",null,null,null,null,null,null,null,null,"Client Expenses",19,"Susan W. Eaton"]
[null,"Computers",0,"Kim Ralls",null,null,null,null,null,null,null,null,"Computers",0,"Kim Ralls"]
[null,"Medical Plan",8,"Kathie Flood",null,null,null,null,null,null,null,null,"Medical Plan",8,"Kathie Flood"]