{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Q","Start","Bill","Mike(MODE)","Mike(MEDIAN)","Sheet1","Sheet2","Sheet3","(1)","(2)","(3)","(4)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":6,"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":"Q","index":0,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Frequency","Value"]
[10,1,null,null,"Expected Result:"]
[5,2]
[4,3,null,null,null,"1st","2nd","3rd","4th","5th"]
[2,4,null,null,"MODE",1,5,{"$f":"IF(COLUMNS($F19:H19)>$F$16,\"\",INDEX($B$16:$B$24,MATCH(COLUMNS($F19:H19),$C$16:$C$24,0)))","v":""},{"$f":"IF(COLUMNS($F19:I19)>$F$16,\"\",INDEX($B$16:$B$24,MATCH(COLUMNS($F19:I19),$C$16:$C$24,0)))","v":""},{"$f":"IF(COLUMNS($F19:J19)>$F$16,\"\",INDEX($B$16:$B$24,MATCH(COLUMNS($F19:J19),$C$16:$C$24,0)))","v":""}]
[10,5]
[9,6,null,null,"Expected Result:"]
[5,7]
[6,8,null,null,"MEDAIN",5]
[2,9]

{"sheet":"Start","index":1,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Frequency","Value"]
[10,1]
[5,2]
[4,3]
[2,4]
[10,5]
[9,6]
[5,7]
[6,8]
[2,9]

{"sheet":"Bill","index":2,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,"Median",{"$f":"MEDIAN(L5:L57)","v":5},null,null,null,null,null,null,null,{"$f":"MEDIAN(T5:T57)","v":9}]
[null,null,null,null,null,null,null,null,null,null,"Mode 1:",{"$f":"_xlfn.MODE.MULT(L$5:L$57)","v":1},null,null,null,null,null,null,null,{"$f":"_xlfn.MODE.MULT(T5:T57)","v":10}]
[null,null,null,null,null,null,null,null,null,null,"Mode 2:",5,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,"Mode 3:",{"$error":"#N/A"},null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",1,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",1,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",1,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",1,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",1,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",1,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",1,null,null,null,null,null,null,null,10]
["dgarofalo100 at YouTube",null,null,null,null,null,null,null,null,null,"Unwind:",1,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",1,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",1,null,null,null,null,null,null,null,10]
["Frequency","Value",null,null,null,null,null,null,null,null,"Unwind:",2,null,null,null,null,null,null,null,5]
[10,1,null,null,"Expected Result:",null,null,null,null,null,"Unwind:",2,null,null,null,null,null,null,null,5]
[5,2,null,null,null,null,null,null,null,null,"Unwind:",2,null,null,null,null,null,null,null,5]
[4,3,null,null,null,"1st","2nd","3rd","4th","5th","Unwind:",2,null,null,null,null,null,null,null,5]
[2,4,null,null,"Median",1,5,{"$f":"IF(COLUMNS($F19:H19)>$F$16,\"\",INDEX($B$16:$B$24,MATCH(COLUMNS($F19:H19),$C$16:$C$24,0)))","v":""},{"$f":"IF(COLUMNS($F19:I19)>$F$16,\"\",INDEX($B$16:$B$24,MATCH(COLUMNS($F19:I19),$C$16:$C$24,0)))","v":""},{"$f":"IF(COLUMNS($F19:J19)>$F$16,\"\",INDEX($B$16:$B$24,MATCH(COLUMNS($F19:J19),$C$16:$C$24,0)))","v":""},"Unwind:",2,null,null,null,null,null,null,null,5]
[10,5,null,null,null,null,null,null,null,null,"Unwind:",3,null,null,null,null,null,null,null,4]
[9,6,null,null,null,null,null,null,null,null,"Unwind:",3,null,null,null,null,null,null,null,4]
[5,7,null,null,null,null,null,null,null,null,"Unwind:",3,null,null,null,null,null,null,null,4]
[6,8,null,null,null,null,null,null,null,null,"Unwind:",3,null,null,null,null,null,null,null,4]
[2,9,null,null,null,null,null,null,null,null,"Unwind:",4,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",4,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",5,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",5,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",5,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",5,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",5,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",5,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",5,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",5,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",5,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",5,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",6,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",6,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",6,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",6,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",6,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",6,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",6,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",6,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",6,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",7,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",7,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",7,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",7,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",7,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",8,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",8,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",8,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",8,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",8,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",8,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",9,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,"Unwind:",9,null,null,null,null,null,null,null,2]

{"sheet":"Mike(MODE)","index":3,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Max",{"$f":"MAX(B5:B13)","v":10}]
["Count",{"$f":"COUNTIF(B5:B13,B1)","v":2}]
[]
[null,"Frequency","Value",null,1,2,3,4]
[{"$f":"(B5=$B$1)+A4","v":1},10,1,null,{"$f":"IFERROR(VLOOKUP(E4,$A$5:$C$13,3,0),\"\")","v":1},{"$f":"IFERROR(VLOOKUP(F4,$A$5:$C$13,3,0),\"\")","v":5},"",""]
[{"$f":"(B6=$B$1)+A5","v":1},5,2]
[1,4,3]
[1,2,4]
[2,10,5]
[2,9,6]
[2,5,7]
[2,6,8,null,"Excel 2003 Method:"]
[2,2,9,null,"Excel Magic Trick 333: #DIV/0! Error IF & ISERROR or IFERROR functions"]

{"sheet":"Mike(MEDIAN)","index":4,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Max",{"$f":"MAX(A5:A13)","v":10}]
["Median",{"$f":"MEDIAN(C5:L13)","v":5}]
[]
["Frequency","Value",1,2,3,4,5,6,7,8,9,10]
[10,1,{"$f":"IF(C$4>$A5,\"\",$B5)","v":1},{"$f":"IF(D$4>$A5,\"\",$B5)","v":1},1,1,1,1,1,1,1,1]
[5,2,{"$f":"IF(C$4>$A6,\"\",$B6)","v":2},2,2,2,2,"","","","",""]
[4,3,3,3,3,3,"","","","","",""]
[2,4,4,4,"","","","","","","",""]
[10,5,5,5,5,5,5,5,5,5,5,5]
[9,6,6,6,6,6,6,6,6,6,6,""]
[5,7,7,7,7,7,7,"","","","",""]
[6,8,8,8,8,8,8,8,"","","",""]
[2,9,9,9,"","","","","","","",""]

{"sheet":"Sheet1","index":5,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Max",{"$f":"MAX(B5:B13)","v":10}]
["count",{"$f":"COUNTIF(B5:B13,B1)","v":2}]
[]
[null,"Frequency","Value",null,1,2,3,4]
[{"$f":"(B5=$B$1)+A4","v":1},10,1,null,{"$f":"IFERROR(VLOOKUP(E4,$A$5:$C$13,3,0),\"\")","v":1},{"$f":"IFERROR(VLOOKUP(F4,$A$5:$C$13,3,0),\"\")","v":5},"",""]
[{"$f":"(B6=$B$1)+A5","v":1},5,2]
[1,4,3,null,"Excel 2003 Method:"]
[1,2,4,null,"Excel Magic Trick 333: #DIV/0! Error IF & ISERROR or IFERROR functions"]
[2,10,5]
[2,9,6]
[2,5,7]
[2,6,8]
[2,2,9]

{"sheet":"Sheet2","index":6,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Max",{"$f":"MAX(A5:A13)","v":10}]
["Median",{"$f":"MEDIAN(C5:L13)","v":5}]
[]
["Frequency","Value",1,2,3,4,5,6,7,8,9,10]
[10,1,{"$f":"IF(C$4>$A5,\"\",$B5)","v":1},{"$f":"IF(D$4>$A5,\"\",$B5)","v":1},1,1,1,1,1,1,1,1]
[5,2,{"$f":"IF(C$4>$A6,\"\",$B6)","v":2},2,2,2,2,"","","","",""]
[4,3,3,3,3,3,"","","","","",""]
[2,4,4,4,"","","","","","","",""]
[10,5,5,5,5,5,5,5,5,5,5,5]
[9,6,6,6,6,6,6,6,6,6,6,""]
[5,7,7,7,7,7,7,"","","","",""]
[6,8,8,8,8,8,8,8,"","","",""]
[2,9,9,9,"","","","","","","",""]

{"sheet":"Sheet3","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"(1)","index":8,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["dgarofalo100 at YouTube"]
[]
[]
["Frequency","Value","MAX?",null,"Max",{"$f":"MAX(A16:A24)","v":10}]
[10,1,{"$f":"(A16=$F$15)+0","v":1},null,"Count",{"$f":"COUNTIF(A16:A24,F15)","v":2}]
[5,2,{"$f":"(A17=$F$15)+C16","v":1}]
[4,3,{"$f":"(A18=$F$15)+C17","v":1},null,null,1,2,3,4,5]
[2,4,1,null,"Median",{"$f":"IFERROR(INDEX($B$16:$B$24,MATCH(F18,$C$16:$C$24,0)),\"\")","v":1},{"$f":"IFERROR(INDEX($B$16:$B$24,MATCH(G18,$C$16:$C$24,0)),\"\")","v":5},"","",""]
[10,5,2]
[9,6,2,null,"Requires Extra Column and does not require array formula"]
[5,7,2]
[6,8,2]
[2,9,2]

{"sheet":"(2)","index":9,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["dgarofalo100 at YouTube"]
[]
[]
["Frequency","Value","MAX?",null,"Max",{"$f":"MAX(A16:A24)","v":10}]
[10,1,{"$f":"SUM(C15,A16=$F$15)","v":1},null,"Count",{"$f":"COUNTIF(A16:A24,F15)","v":2}]
[5,2,{"$f":"SUM(C16,A17=$F$15)","v":1}]
[4,3,1,null,null,"1st","2nd","3rd","4th","5th"]
[2,4,1,null,"Median",{"$f":"IFERROR(INDEX($B$16:$B$24,MATCH(COLUMNS($F19:F19),$C$16:$C$24,0)),\"\")","v":1},{"$f":"IFERROR(INDEX($B$16:$B$24,MATCH(COLUMNS($F19:G19),$C$16:$C$24,0)),\"\")","v":5},{"$f":"IFERROR(INDEX($B$16:$B$24,MATCH(COLUMNS($F19:H19),$C$16:$C$24,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$16:$B$24,MATCH(COLUMNS($F19:I19),$C$16:$C$24,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$16:$B$24,MATCH(COLUMNS($F19:J19),$C$16:$C$24,0)),\"\")","v":""}]
[10,5,2]
[9,6,2,null,"Requires Extra Column and does not require array formula"]
[5,7,2]
[6,8,2]
[2,9,2]

{"sheet":"(3)","index":10,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["dgarofalo100 at YouTube"]
[]
[]
["Frequency","Value",null,null,"Max",{"$f":"MAX(A16:A24)","v":10}]
[10,1,null,null,"Count",{"$f":"COUNTIF(A16:A24,F15)","v":2}]
[5,2]
[4,3,null,null,null,"1st","2nd","3rd","4th","5th"]
[2,4,null,null,"Median",{"$f":"IF(COLUMNS($F19:F19)>$F$16,\"\",INDEX($B$16:$B$24,SMALL(IF($A$16:$A$24=$F$15,ROW($A$16:$A$24)-ROW($A$16)+1),COLUMNS($F19:F19))))","v":1},{"$f":"IF(COLUMNS($F19:G19)>$F$16,\"\",INDEX($B$16:$B$24,SMALL(IF($A$16:$A$24=$F$15,ROW($A$16:$A$24)-ROW($A$16)+1),COLUMNS($F19:G19))))","v":5},{"$f":"IF(COLUMNS($F19:H19)>$F$16,\"\",INDEX($B$16:$B$24,SMALL(IF($A$16:$A$24=$F$15,ROW($A$16:$A$24)-ROW($A$16)+1),COLUMNS($F19:H19))))","v":""},{"$f":"IF(COLUMNS($F19:I19)>$F$16,\"\",INDEX($B$16:$B$24,SMALL(IF($A$16:$A$24=$F$15,ROW($A$16:$A$24)-ROW($A$16)+1),COLUMNS($F19:I19))))","v":""},{"$f":"IF(COLUMNS($F19:J19)>$F$16,\"\",INDEX($B$16:$B$24,SMALL(IF($A$16:$A$24=$F$15,ROW($A$16:$A$24)-ROW($A$16)+1),COLUMNS($F19:J19))))","v":""}]
[10,5]
[9,6,null,null,"Requires Key Strokes Crtl + Shift + Enter"]
[5,7]
[6,8]
[2,9]

{"sheet":"(4)","index":11,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["dgarofalo100 at YouTube"]
[]
[]
["Frequency","Value",null,null,"Max",{"$f":"MAX(A16:A24)","v":10}]
[10,1,null,null,"Count",{"$f":"COUNTIF(A16:A24,F15)","v":2}]
[5,2]
[4,3,null,null,null,"1st","2nd","3rd","4th","5th"]
[2,4,null,null,"Median",{"$f":"IF(COLUMNS($F19:F19)>$F$16,\"\",INDEX($B$16:$B$24,_xlfn.AGGREGATE(15,6,(ROW($A$16:$A$24)-ROW($A$16)+1)/($A$16:$A$24=$F$15),COLUMNS($F19:F19))))","v":1},{"$f":"IF(COLUMNS($F19:G19)>$F$16,\"\",INDEX($B$16:$B$24,_xlfn.AGGREGATE(15,6,(ROW($A$16:$A$24)-ROW($A$16)+1)/($A$16:$A$24=$F$15),COLUMNS($F19:G19))))","v":5},{"$f":"IF(COLUMNS($F19:H19)>$F$16,\"\",INDEX($B$16:$B$24,_xlfn.AGGREGATE(15,6,(ROW($A$16:$A$24)-ROW($A$16)+1)/($A$16:$A$24=$F$15),COLUMNS($F19:H19))))","v":""},{"$f":"IF(COLUMNS($F19:I19)>$F$16,\"\",INDEX($B$16:$B$24,_xlfn.AGGREGATE(15,6,(ROW($A$16:$A$24)-ROW($A$16)+1)/($A$16:$A$24=$F$15),COLUMNS($F19:I19))))","v":""},{"$f":"IF(COLUMNS($F19:J19)>$F$16,\"\",INDEX($B$16:$B$24,_xlfn.AGGREGATE(15,6,(ROW($A$16:$A$24)-ROW($A$16)+1)/($A$16:$A$24=$F$15),COLUMNS($F19:J19))))","v":""}]
[10,5]
[9,6,null,null,"Uses Excel 2010 function AGGREGATE"]
[5,7]
[6,8]
[2,9]