{"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":[]}
["SMALL Function"]
[null,"automateexcel.com/functions/small-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":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"SMALL",null,"=SMALL (array, k)"]
[]
[null,"The Excel SMALL function returns numeric values based on their position in a list ranked by value."]
[]
[null,"Name","Start Time","End Time","Time",null,"Place","Rank #","Time"]
[null,"Jeremy John","08:00:00","10:10:10",{"$f":"D7-C7","v":"02:10:10"},null,"Winner",1,{"$f":"SMALL(E$7:E$13,H7)","v":"02:01:50"}]
[null,"John Smith","08:00:00","10:25:45",{"$f":"D8-C8","v":"02:25:45"},null,"2nd Place",2,{"$f":"SMALL(E$7:E$13,H8)","v":"02:10:10"}]
[null,"Justin Gatt","08:00:00","11:01:24","03:01:24",null,"3rd Place",3,"02:25:45"]
[null,"Sarah Samuel","08:00:00","10:40:02","02:40:02",null,"5th Place",5,"02:40:02"]
[null,"Gen Smith","08:00:00","10:01:50","02:01:50",null,"7th Place",7,"03:01:24"]
[null,"Troy Hollis","08:00:00","10:33:44",{"$f":"D12-C12","v":"02:33:44"}]
[null,"Brown Ducan","08:00:00","10:43:53","02:43:53"]
[]
[null,"automateexcel.com/functions/small-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 1","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Runner","Run Time(min) ",null,"Item","Run Time (min)"]
["Barry",90,null,"Winner",{"$f":"SMALL($B$2:$B$9,1)","v":59}]
["Cisco",59,null,"First Runner-Up",{"$f":"SMALL($B$2:$B$9,2)","v":69}]
["Paige",93,null,"Second Runner-Up",{"$f":"SMALL($B$2:$B$9,3)","v":77}]
["Walter",81]
["Toby",93]
["Gabe",77]
["Erin",69]
["Andrew",85]
[]
[null,"automateexcel.com/functions/small-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 2","index":3,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Runner","Run Time(min) ",null,"Result"]
["Barry",90,null,{"$f":"SMALL(B2:B9, 9)","v":{"$error":"#NUM!"}}]
["Cisco",59]
["Paige",93]
["Walter",81]
["Toby",93]
["Gabe",77]
["Erin",69]
["Andrew",85]
[]
[null,"automateexcel.com/functions/small-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 3","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Runner","Run Time(min) ",null,"Result"]
["Barry",90,null,{"$f":"SMALL(B2:B9, 5)","v":90}]
["Cisco",59]
["Paige",93]
["Walter","-"]
["Toby",93]
["Gabe",77]
["Erin",69]
["Andrew",85]
[]
[null,"automateexcel.com/functions/small-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 4","index":5,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Runner","Age","Run Time(min) ",null,"Fastest Runner","Result"]
["Barry",20,90,null,"Over the age 25",{"$f":"SMALL( IF(B2:B9 >= 25, C2:C9), 1)","v":69}]
["Cisco",21,59]
["Paige",23,93]
["Walter",25,73]
["Toby",25,93]
["Gabe",26,77]
["Erin",28,69]
["Andrew",29,85]
[]
[null,"automateexcel.com/functions/small-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 5","index":6,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Run Time(min) ","Sorted Run Time(min) "]
[90,{"$f":"SMALL($A$2:$A$9,  ROW()-1)","v":59}]
[59,{"$f":"SMALL($A$2:$A$9,  ROW()-1)","v":69}]
[93,77]
[81,81]
[96,85]
[77,90]
[69,93]
[85,96]
[]
[null,"automateexcel.com/functions/small-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]