{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["LARGE","AGGREGATE","SUMPRODUCT","VBA","LSI 1"],"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":"LARGE","index":0,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,14]]}
[]
[null,"Using LARGE Function",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Club Name","Home Kit","Away Kit",null,"Kit Version",null,null,null,null,"Club Name","Home Kit","Away Kit",null,"Kit Version"]
[null,"Chelsea",119,95,null,"Home Kit",null,null,null,null,"Chelsea",119,95,null,"Home Kit"]
[null,"Liverpool",99,70,null,"Second Largest Price",null,null,null,null,"Liverpool",99,70,null,"Second Largest Price"]
[null,"Man United",70,65,null,{"$f":"LARGE(IF(C4:D4=F5,C5:D12),2)","v":119},null,null,null,null,"Man United",70,65,null,{"$f":"LARGE(IF(L4:M4=O5,L5:M12),2)","v":119}]
[null,"Man City",90,80,null,null,null,null,null,null,"Man City",90,80]
[null,"Real Madrid",125,107,null,null,null,null,null,null,"Real Madrid",125,107]
[null,"Barcelona",115,100,null,null,null,null,null,null,"Barcelona",115,100]

{"sheet":"AGGREGATE","index":1,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,14]]}
[]
[null,"Using AGGREGATE Function",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Club Name","Home Kit","Away Kit",null,"Kit Version",null,null,null,null,"Club Name","Home Kit","Away Kit",null,"Kit Version"]
[null,"Chelsea",119,95,null,"Away Kit",null,null,null,null,"Chelsea",119,95,null,"Away Kit"]
[null,"Liverpool",99,70,null,"Second Largest Price",null,null,null,null,"Liverpool",99,70,null,"Second Largest Price"]
[null,"Man United",70,65,null,{"$f":"_xlfn.AGGREGATE(14,6,(C5:E12)/(C4:E4=F5),2)","v":100},null,null,null,null,"Man United",70,65,null,{"$f":"_xlfn.AGGREGATE(14,6,(L5:N12)/(L4:N4=O5),2)","v":100}]
[null,"Man City",90,80,null,null,null,null,null,null,"Man City",90,80]
[null,"Real Madrid",125,107,null,null,null,null,null,null,"Real Madrid",125,107]
[null,"Barcelona",115,100,null,null,null,null,null,null,"Barcelona",115,100]

{"sheet":"SUMPRODUCT","index":2,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,14]]}
[]
[null,"Using SUMPRODUCT Function",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Club Name","Home Kit","Away Kit",null,"Club Name",null,null,null,null,"Club Name","Home Kit","Away Kit",null,"Club Name"]
[null,"Chelsea",119,95,null,{"$f":"B8","v":"Man City"},null,null,null,null,"Chelsea",119,95,null,{"$f":"K8","v":"Man City"}]
[null,"Liverpool",99,70,null,"Second Largest Price",null,null,null,null,"Liverpool",99,70,null,"Second Largest Price"]
[null,"Man United",70,65,null,{"$f":"SUMPRODUCT(LARGE((B5:B12=F5)*(C5:E12),2))","v":80},null,null,null,null,"Man United",70,65,null,{"$f":"SUMPRODUCT(LARGE((K5:K12=O5)*(L5:N12),2))","v":80}]
[null,"Man City",90,80,null,null,null,null,null,null,"Man City",90,80]
[null,"Real Madrid",125,107,null,null,null,null,null,null,"Real Madrid",125,107]
[null,"Barcelona",115,100,null,null,null,null,null,null,"Barcelona",115,100]

{"sheet":"VBA","index":3,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,14]]}
[]
[null,"Using VBA Code",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Club Name","Home Kit","Away Kit",null,"Club Name",null,null,null,null,"Club Name","Home Kit","Away Kit",null,"Club Name"]
[null,"Chelsea",119,95,null,{"$f":"D4","v":"Away Kit"},null,null,null,null,"Chelsea",119,95,null,{"$f":"M4","v":"Away Kit"}]
[null,"Liverpool",99,70,null,"Second Largest",null,null,null,null,"Liverpool",99,70,null,"Second Largest"]
[null,"Man United",70,65,null,{"$f":"LARGE(IF(C4:D4=F5,C5:D12),2)","v":100},null,null,null,null,"Man United",70,65,null,{"$f":"LARGE(IF(L4:M4=O5,L5:M12),2)","v":100}]
[null,"Man City",90,80,null,null,null,null,null,null,"Man City",90,80]
[null,"Real Madrid",125,107,null,null,null,null,null,null,"Real Madrid",125,107]
[null,"Barcelona",115,100,null,null,null,null,null,null,"Barcelona",115,100]

{"sheet":"LSI 1","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Finding Top 5 Values"]
[]
[null,"Club Name","Home Kit",null,"Top 5 Values"]
[null,"Chelsea",119,null,{"$f":"LARGE($C$5:$C$10,ROWS($E$5:$E5))","v":125}]
[null,"Liverpool",99,null,{"$f":"LARGE($C$5:$C$10,ROWS($E$5:$E6))","v":119}]
[null,"Man United",70,null,{"$f":"LARGE($C$5:$C$10,ROWS($E$5:$E7))","v":115}]
[null,"Man City",90,null,{"$f":"LARGE($C$5:$C$10,ROWS($E$5:$E8))","v":99}]
[null,"Real Madrid",125,null,{"$f":"LARGE($C$5:$C$10,ROWS($E$5:$E9))","v":90}]
[null,"Barcelona",115]