{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Sheet4","Table","Pivot","VBA","MIN Function","Min Function- 2","Sheet5","SMALL Function","SMALL Function- 2","Criteria-MIN-IF","Criteria-MINIFS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":2},"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":"Sheet4","index":0,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Pivot Table to Find Minimum Value"]
[]
[null,"Row Labels","Min of English","Min of History","Min of Science","Min of Math"]
[null,"Alex",70,33,58,45]
[null,"David",70,87,90,90]
[null,"Jay",78,76,95,81]
[null,"Jordan",55,70,79,88]
[null,"Mick",89,88,65,100]
[null,"Moses",88,67,55,45]
[null,"Nathan",61,77,80,77]
[null,"Noah",55,45,67,79]
[null,"Peter",88,76,90,100]
[null,"Rod",53,75,75,73]
[null,"Rodric",90,66,45,88]
[null,"Ryan",40,48,56,60]
[null,"Yusuf",66,78,69,70]
[null,"Grand Total",40,33,45,45]

{"sheet":"Table","index":1,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Pivot Table to Find Minimum Value"]
[]
[null,"Student Name","English","History","Science","Math"]
[null,"Peter",88,76,90,100]
[null,"Jay",78,76,95,81]
[null,"Mick",89,88,65,100]
[null,"Noah",55,45,67,79]
[null,"Alex",70,33,58,45]
[null,"Rod",53,75,75,73]
[null,"Ryan",40,48,56,60]
[null,"Yusuf",66,78,69,70]
[null,"David",70,87,90,90]
[null,"Moses",88,67,55,45]
[null,"Rodric",90,66,45,88]
[null,"Jordan",55,70,79,88]
[null,"Nathan",61,77,80,77]

{"sheet":"Pivot","index":2,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Row Labels","Min of Science"]
[null,"Alex",58]
[null,"David",90]
[null,"Jay",95]
[null,"Jordan",79]
[null,"Mick",65]
[null,"Moses",55]
[null,"Nathan",80]
[null,"Noah",67]
[null,"Peter",90]
[null,"Rod",75]
[null,"Rodric",45]
[null,"Ryan",56]
[null,"Yusuf",69]
[null,"Grand Total",45]

{"sheet":"VBA","index":3,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null," Applying VBA Code to Find Minimum Value",null,null,null,null,null," Practice Yourself"]
[]
[null,"Student \nName","English","History","Science","Math",null,"Student \nName","English","History","Science","Math"]
[null,"Peter",88,76,90,100,null,"Peter",88,76,90,100]
[null,"Jay",78,76,95,81,null,"Jay",78,76,95,81]
[null,"Mick",89,88,65,100,null,"Mick",89,88,65,100]
[null,"Noah",55,45,67,79,null,"Noah",55,45,67,79]
[null,"Alex",70,33,58,45,null,"Alex",70,33,58,45]
[null,"Rod",53,75,75,73,null,"Rod",53,75,75,73]
[null,"Ryan",40,48,56,60,null,"Ryan",40,48,56,60]
[null,"Mick",50,78,69,70,null,"Mick",50,78,69,70]
[null,"David",70,87,90,90,null,"David",70,87,90,90]
[null,"Moses",88,67,55,45,null,"Moses",88,67,55,45]
[null,"Rodric",90,66,45,88,null,"Rodric",90,66,45,88]
[null,"Jordan",55,70,79,88,null,"Jordan",55,70,79,88]
[null,"Nathan",61,77,80,77,null,"Nathan",61,77,80,77]
[]
[null,"Minimum Value ",33,null,null,null,null,"Minimum Value "]

{"sheet":"MIN Function","index":4,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null," Finding Minimum Value Within Row"]
[]
[null,"Student Name","English","History","Science","Math",null,"Each Student\n MIN Score"]
[null,"Peter",88,76,90,100,null,{"$f":"MIN(C5:F5)","v":76}]
[null,"Jay",78,76,95,81,null,{"$f":"MIN(C6:F6)","v":76}]
[null,"Mick",89,88,65,100,null,65]
[null,"Noah",55,45,67,79,null,45]
[null,"Alex",70,33,58,45,null,33]
[null,"Rod",53,75,75,73,null,53]
[null,"Ryan",40,48,56,60,null,40]
[null,"Yusuf",66,78,69,70,null,66]
[null,"David",70,87,90,90,null,70]
[null,"Moses",88,67,55,45,null,45]
[null,"Rodric",90,66,45,88,null,45]
[null,"Jordan",55,70,79,88,null,55]
[null,"Nathan",61,77,80,77,null,61]

{"sheet":"Min Function- 2","index":5,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null," Finding Minimum Value Within Column"]
[]
[null,"Student Name","English","History","Science","Math"]
[null,"Peter",88,76,90,100]
[null,"Jay",78,76,95,81]
[null,"Mick",89,88,65,100]
[null,"Noah",55,45,67,79]
[null,"Alex",70,33,58,45]
[null,"Rod",53,75,75,73]
[null,"Ryan",40,48,56,60]
[null,"Mick",50,78,69,70]
[null,"David",70,87,90,90]
[null,"Moses",88,67,55,45]
[null,"Rodric",90,66,45,88]
[null,"Jordan",55,70,79,88]
[null,"Nathan",61,77,80,77]
[]
[null,"MIN Score in Each Course",{"$f":"MIN(C5:C17)","v":40},{"$f":"MIN(D5:D17)","v":33},45,45]

{"sheet":"Sheet5","index":6,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Sample Data Set"]
[]
[null,"Student Name","English","History","Science","Math"]
[null,"Peter",88,76,90,100]
[null,"Jay",78,76,95,81]
[null,"Mick",89,88,65,100]
[null,"Noah",55,45,67,79]
[null,"Alex",70,33,58,45]
[null,"Rod",53,75,75,73]
[null,"Ryan",40,48,56,60]
[null,"Mick",50,78,69,70]
[null,"David",70,87,90,90]
[null,"Moses",88,67,55,45]
[null,"Rodric",90,66,45,88]
[null,"Jordan",55,70,79,88]
[null,"Nathan",61,77,80,77]

{"sheet":"SMALL Function","index":7,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null," Finding Minimum Value Within Row"]
[]
[null,"Student Name","English","History","Science","Math",null,"Each Student \nMIN Score"]
[null,"Peter",88,76,90,100,null,{"$f":"SMALL(C5:F5,1)","v":76}]
[null,"Jay",78,76,95,81,null,{"$f":"SMALL(C6:F6,1)","v":76}]
[null,"Mick",89,88,65,100,null,65]
[null,"Noah",55,45,67,79,null,45]
[null,"Alex",70,33,58,45,null,33]
[null,"Rod",53,75,75,73,null,53]
[null,"Ryan",40,48,56,60,null,40]
[null,"Mick",50,78,69,70,null,50]
[null,"David",70,87,90,90,null,70]
[null,"Moses",88,67,55,45,null,45]
[null,"Rodric",90,66,45,88,null,45]
[null,"Jordan",55,70,79,88,null,55]
[null,"Nathan",61,77,80,77,null,61]

{"sheet":"SMALL Function- 2","index":8,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null," Finding Minimum Value Within Column"]
[]
[null,"Student \nName","English","History","Science","Math"]
[null,"Peter",88,76,90,100]
[null,"Jay",78,76,95,81]
[null,"Mick",89,88,65,100]
[null,"Noah",55,45,67,79]
[null,"Alex",70,33,58,45]
[null,"Rod",53,75,75,73]
[null,"Ryan",40,48,56,60]
[null,"Mick",50,78,69,70]
[null,"David",70,87,90,90]
[null,"Moses",88,67,55,45]
[null,"Rodric",90,66,45,88]
[null,"Jordan",55,70,79,88]
[null,"Nathan",61,77,80,77]
[]
[null,"MIN Score in Each Course",{"$f":"SMALL(C5:C17,1)","v":40},{"$f":"SMALL(D5:D17,1)","v":33},45,45]

{"sheet":"Criteria-MIN-IF","index":9,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null," Combining MIN and IF Functions"]
[]
[null,"Student Name","English","History","Science","Math",null,"Student Name","Min Score"]
[null,"Peter",88,76,90,100,null,"Mick",{"$f":"MIN(IF(B5:B17=H5,C5:F17))","v":50}]
[null,"Jay",78,76,95,81]
[null,"Mick",89,88,65,100]
[null,"Noah",55,45,67,79]
[null,"Alex",70,33,58,45]
[null,"Rod",53,75,75,73]
[null,"Ryan",40,48,56,60]
[null,"Mick",50,78,69,70]
[null,"David",70,87,90,90]
[null,"Moses",88,67,55,45]
[null,"Rodric",90,66,45,88]
[null,"Jordan",55,70,79,88]
[null,"Nathan",61,77,80,77]

{"sheet":"Criteria-MINIFS","index":10,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Inserting MINIFS function"]
[]
[null,"Student Name","English","History","Science","Math",null,"Student Name","Min Score"]
[null,"Peter",88,76,90,100,null,"Ryan",{"$f":"_xlfn.MINIFS(C5:C17,B5:B17,H5)","v":40}]
[null,"Jay",78,76,95,81]
[null,"Mick",89,88,65,100]
[null,"Noah",55,45,67,79]
[null,"Alex",70,33,58,45]
[null,"Rod",53,75,75,73]
[null,"Ryan",40,48,56,60]
[null,"Mick",50,78,69,70]
[null,"David",70,87,90,90]
[null,"Moses",88,67,55,45]
[null,"Rodric",90,66,45,88]
[null,"Jordan",55,70,79,88]
[null,"Nathan",61,77,80,77]