{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","MIN,IF","MIN,IF,MAX","MIN,NOT,MAX","MIN,FILTER","INDEX-MATCH","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":"Dataset","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Inventory List of ABC Technology"]
[]
[null,"Product ID","Product Name","Units Remaining"]
[null,"AT001","iPhone 14 Pro Max",8]
[null,"AT002","Bose QuietComfort",10]
[null,"AT003","Oura Gen 3 Ring",6]
[null,"AT004","Amazon Kindle",0]
[null,"AT005","MacBook Air M2",5]
[null,"AT006","Fiture Mini",2]
[null,"AT007","Roomba j7+",8]
[null,"AT008","Logitech MX Master",3]
[null,"AT009","Yale Assure Lock 2",0]
[null,"AT010","Galaxy Tab S8 Plus",5]

{"sheet":"MIN,IF","index":1,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[15,1,15,2],[15,7,15,8],[1,7,1,9]]}
[]
[null,"Using MIN and IF Functions",null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product ID","Product Name","Units Remaining",null,null,null,"Product ID","Product Name","Units Remaining"]
[null,"AT001","iPhone 14 Pro Max",8,null,null,null,"AT001","iPhone 14 Pro Max",20]
[null,"AT002","Bose QuietComfort",10,null,null,null,"AT002","Bose QuietComfort",25]
[null,"AT003","Oura Gen 3 Ring",6,null,null,null,"AT003","Oura Gen 3 Ring",15]
[null,"AT004","Amazon Kindle",0,null,null,null,"AT004","Amazon Kindle",0]
[null,"AT005","MacBook Air M2",5,null,null,null,"AT005","MacBook Air M2",17]
[null,"AT006","Fiture Mini",2,null,null,null,"AT006","Fiture Mini",12]
[null,"AT007","Roomba j7+",8,null,null,null,"AT007","Roomba j7+",8]
[null,"AT008","Logitech MX Master",3,null,null,null,"AT008","Logitech MX Master",13]
[null,"AT009","Yale Assure Lock 2",0,null,null,null,"AT009","Yale Assure Lock 2",0]
[null,"AT010","Galaxy Tab S8 Plus",5,null,null,null,"AT010","Galaxy Tab S8 Plus",7]
[]
[null,"Minimum Units Excluding Zero",null,{"$f":"MIN(IF(D5:D14<>0,D5:D14))","v":2},null,null,null,"Minimum Units Excluding Zero"]

{"sheet":"MIN,IF,MAX","index":2,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[15,1,15,2],[15,7,15,8],[1,7,1,9]]}
[]
[null,"Utilizing MIN, IF and MAX Functions",null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product ID","Product Name","Units Remaining",null,null,null,"Product ID","Product Name","Units Remaining"]
[null,"AT001","iPhone 14 Pro Max",8,null,null,null,"AT001","iPhone 14 Pro Max",20]
[null,"AT002","Bose QuietComfort",10,null,null,null,"AT002","Bose QuietComfort",25]
[null,"AT003","Oura Gen 3 Ring",6,null,null,null,"AT003","Oura Gen 3 Ring",15]
[null,"AT004","Amazon Kindle",0,null,null,null,"AT004","Amazon Kindle",0]
[null,"AT005","MacBook Air M2",5,null,null,null,"AT005","MacBook Air M2",17]
[null,"AT006","Fiture Mini",2,null,null,null,"AT006","Fiture Mini",12]
[null,"AT007","Roomba j7+",8,null,null,null,"AT007","Roomba j7+",8]
[null,"AT008","Logitech MX Master",3,null,null,null,"AT008","Logitech MX Master",13]
[null,"AT009","Yale Assure Lock 2",0,null,null,null,"AT009","Yale Assure Lock 2",0]
[null,"AT010","Galaxy Tab S8 Plus",5,null,null,null,"AT010","Galaxy Tab S8 Plus",7]
[]
[null,"Minimum Units Excluding Zero",null,{"$f":"MIN(IF(D5:D14=0,MAX(D5:D14),D5:D14))","v":2},null,null,null,"Minimum Units Excluding Zero"]

{"sheet":"MIN,NOT,MAX","index":3,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[15,1,15,2],[15,7,15,8],[1,7,1,9]]}
[]
[null,"Incorporating MIN, NOT, and MAX Functions",null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product ID","Product Name","Units Remaining",null,null,null,"Product ID","Product Name","Units Remaining"]
[null,"AT001","iPhone 14 Pro Max",8,null,null,null,"AT001","iPhone 14 Pro Max",20]
[null,"AT002","Bose QuietComfort",10,null,null,null,"AT002","Bose QuietComfort",25]
[null,"AT003","Oura Gen 3 Ring",6,null,null,null,"AT003","Oura Gen 3 Ring",15]
[null,"AT004","Amazon Kindle",0,null,null,null,"AT004","Amazon Kindle",0]
[null,"AT005","MacBook Air M2",5,null,null,null,"AT005","MacBook Air M2",17]
[null,"AT006","Fiture Mini",2,null,null,null,"AT006","Fiture Mini",12]
[null,"AT007","Roomba j7+",8,null,null,null,"AT007","Roomba j7+",8]
[null,"AT008","Logitech MX Master",3,null,null,null,"AT008","Logitech MX Master",13]
[null,"AT009","Yale Assure Lock 2",0,null,null,null,"AT009","Yale Assure Lock 2",0]
[null,"AT010","Galaxy Tab S8 Plus",5,null,null,null,"AT010","Galaxy Tab S8 Plus",7]
[]
[null,"Minimum Units Excluding Zero",null,{"$f":"MIN(NOT(D5:D14)*MAX(D5:D14)+D5:D14)","v":2},null,null,null,"Minimum Units Excluding Zero"]

{"sheet":"MIN,FILTER","index":4,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[15,1,15,2],[15,7,15,8],[1,7,1,9]]}
[]
[null,"Applying MIN with FILTER Function",null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product ID","Product Name","Units Remaining",null,null,null,"Product ID","Product Name","Units Remaining"]
[null,"AT001","iPhone 14 Pro Max",8,null,null,null,"AT001","iPhone 14 Pro Max",20]
[null,"AT002","Bose QuietComfort",10,null,null,null,"AT002","Bose QuietComfort",25]
[null,"AT003","Oura Gen 3 Ring",6,null,null,null,"AT003","Oura Gen 3 Ring",15]
[null,"AT004","Amazon Kindle",0,null,null,null,"AT004","Amazon Kindle",0]
[null,"AT005","MacBook Air M2",5,null,null,null,"AT005","MacBook Air M2",17]
[null,"AT006","Fiture Mini",2,null,null,null,"AT006","Fiture Mini",12]
[null,"AT007","Roomba j7+",8,null,null,null,"AT007","Roomba j7+",8]
[null,"AT008","Logitech MX Master",3,null,null,null,"AT008","Logitech MX Master",13]
[null,"AT009","Yale Assure Lock 2",0,null,null,null,"AT009","Yale Assure Lock 2",0]
[null,"AT010","Galaxy Tab S8 Plus",5,null,null,null,"AT010","Galaxy Tab S8 Plus",7]
[]
[null,"Minimum Units Excluding Zero",null,{"$f":"MIN(_xlfn._xlws.FILTER(D5:D14,D5:D14<>0))","v":2},null,null,null,"Minimum Units Excluding Zero"]

{"sheet":"INDEX-MATCH","index":5,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[15,1,15,2],[15,7,15,8],[1,7,1,9]]}
[]
[null,"Implementing INDEX-MATCH Formula with MIN Function",null,null,null,null,null,"Do It Yourself"]
[]
[null,"Product ID","Product Name","Units Remaining",null,null,null,"Product ID","Product Name","Units Remaining"]
[null,"AT001","iPhone 14 Pro Max",8,null,null,null,"AT001","iPhone 14 Pro Max",20]
[null,"AT002","Bose QuietComfort",10,null,null,null,"AT002","Bose QuietComfort",25]
[null,"AT003","Oura Gen 3 Ring",6,null,null,null,"AT003","Oura Gen 3 Ring",15]
[null,"AT004","Amazon Kindle",0,null,null,null,"AT004","Amazon Kindle",0]
[null,"AT005","MacBook Air M2",5,null,null,null,"AT005","MacBook Air M2",17]
[null,"AT006","Fiture Mini",2,null,null,null,"AT006","Fiture Mini",12]
[null,"AT007","Roomba j7+",8,null,null,null,"AT007","Roomba j7+",8]
[null,"AT008","Logitech MX Master",3,null,null,null,"AT008","Logitech MX Master",13]
[null,"AT009","Yale Assure Lock 2",0,null,null,null,"AT009","Yale Assure Lock 2",0]
[null,"AT010","Galaxy Tab S8 Plus",5,null,null,null,"AT010","Galaxy Tab S8 Plus",7]
[]
[null,"Minimum Units Excluding Zero",null,{"$f":"INDEX(D5:D14,MATCH(MIN(IF(D5:D14<>0,D5:D14)),D5:D14,0))","v":2},null,null,null,"Minimum Units Excluding Zero"]

{"sheet":"VBA","index":6,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Min Function to Exclude Zero with VBA"]
[]
[null,"Product ID","Product Name","Units Remaining"]
[null,"AT001","iPhone 14 Pro Max",8]
[null,"AT002","Bose QuietComfort",10]
[null,"AT003","Oura Gen 3 Ring",6]
[null,"AT004","Amazon Kindle",0]
[null,"AT005","MacBook Air M2",5]
[null,"AT006","Fiture Mini",2]
[null,"AT007","Roomba j7+",8]
[null,"AT008","Logitech MX Master",3]
[null,"AT009","Yale Assure Lock 2",0]
[null,"AT010","Galaxy Tab S8 Plus",5]