{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Contents","Introduction AVERAGEIF","Example 1","Example 2","Example 3","Example 4","Example 5"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"Contents","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["LARGE Function"]
[null,"automateexcel.com/functions/large-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction AVERAGEIF",null,null,null,"Excel Formulas w/Examples"]
[null,"Example 1",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Example 2",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"Example 3"]
[null,"Example 4"]
[null,"Example 5"]
[]
[]
[null,"Excel Boot Camp"]
[null,"  Learn Excel Inside Excel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"           Learn Excel inside Excel with our Interactive Tutorial"]
[null,"           Automatically Graded Exercises"]
[null,"           Shortcuts & Best Practices \"Work Smarter, not Harder\""]
[]
[]
[]
[]
[]
[]
[]
[null,"Course Contents"]

{"sheet":"Introduction AVERAGEIF","index":1,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"LARGE",null,"=LARGE (array, k)"]
[]
[null,"The Excel LARGE function returns numeric values based on their position in a list when sorted by value."]
[]
[null,"Name","Game 01 ","Game 02","Game 03","Total Score",null,"Place","Rank #","Time"]
[null,"Jeremy John",88,99,95,{"$f":"D7+C7+E7","v":282},null,"Winner",1,{"$f":"LARGE(F$7:F$13,I7)","v":285}]
[null,"John Smith",99,80,86,{"$f":"D8+C8+E8","v":265},null,"2nd Place",2,{"$f":"LARGE(F$7:F$13,I8)","v":282}]
[null,"Justin Gatt",96,80,89,265,null,"3rd Place",3,{"$f":"LARGE(F$7:F$13,I9)","v":273}]
[null,"Sarah Samuel",89,100,96,285,null,"5th Place",5,{"$f":"LARGE(F$7:F$13,I10)","v":265}]
[null,"Gen Smith",80,83,94,257,null,"7th Place",7,{"$f":"LARGE(F$7:F$13,I11)","v":253}]
[null,"Troy Hollis",84,86,83,253]
[null,"Brown Ducan",89,97,87,273]
[]
[null,"automateexcel.com/functions/large-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 1","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Students","Age",null,"Result"]
["Gari",13,null,{"$f":"LARGE(B2:B8, 3)","v":19}]
["Caine",16]
["Sly",17]
["Andy",19]
["Stanley",20]
["Quin",14]
["Ralph",23]
[]
[null,"automateexcel.com/functions/large-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 2","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Students","Age",null,"Result"]
["Gari",13,null,{"$f":"LARGE(B2:B8, 8)","v":{"$error":"#NUM!"}}]
["Caine",16]
["Sly",17]
["Andy",19]
["Stanley",20]
["Quin",14]
["Ralph",23]
[]
[null,"automateexcel.com/functions/large-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 3","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Students","Age",null,"Result"]
["Gari",13,null,{"$f":"LARGE(B2:B8, 4)","v":16}]
["Caine",16]
["Sly",17]
["Andy","-"]
["Stanley",20]
["Quin",14]
["Ralph",23]
[]
[null,"automateexcel.com/functions/large-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 4","index":5,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Students","Gender","Age",null,"Result"]
["Gari","F",13,null,{"$f":"LARGE(IF(B2:B8 = \"M\", C2:C8), 2)","v":20}]
["Caine","M",16]
["Sly","M",17]
["Andy","M",19]
["Stanley","M",20]
["Quin","F",14]
["Ralph","M",23]
[]
[null,"automateexcel.com/functions/large-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 5","index":6,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Age","Sorted Age"]
[13,{"$f":"LARGE($A$2:$A$8, ROW()-1)","v":23}]
[16,{"$f":"LARGE($A$2:$A$8, ROW()-1)","v":20}]
[17,19]
[19,17]
[20,16]
[14,14]
[23,13]
[]
[null,"automateexcel.com/functions/large-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]