{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Title","Sheet1","Rank","RankCountIf","Mystery","Why","LookInTheXML","Workaround","Sheet9"],"not_rendered":{"charts":0,"images":11,"macros":0,"external_links":0,"defined_names":6,"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2110]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: elljay / Pixabay"]

{"sheet":"Sheet1","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Fundamental Belief About Excel"]
["Numbers only have 15 digits of precision"]
["Try and paste some credit card numbers in Excel and you lose the last digit"]
[]
[null,null,null,null,null,1111222233334440]
[null,null,null,null,null,1111222233334440]
[null,null,null,null,null,1111222233334440]
[null,null,null,null,null,1111222233334440]
[null,null,null,null,null,1111222233334440]
[null,null,null,null,null,1111222233334440]
[null,null,null,null,null,1111222233334440]
[null,null,null,null,null,1111222233334440]
[null,null,null,null,null,1111222233334440]
[null,null,null,null,null,1111222233334440]

{"sheet":"Rank","index":2,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["The RANK function has an odd way of handling ties"]
[]
["Name","Score","Rank",null,null,"How many people are ranked #",null,null,null,null,"Sort with a Formula"]
["Abby",80,{"$f":"RANK(B4,$B$4:$B$13)","v":1},{"$f":"_xlfn.FORMULATEXT(C4)","v":"=RANK(B4,$B$4:$B$13)"},null,1,{"$f":"COUNTIF($C$4:$C$13,F4)","v":1},{"$f":"_xlfn.FORMULATEXT(G4)","v":"=COUNTIF($C$4:$C$13,F4)"},null,null,1,{"$f":"INDEX($A$4:$A$13,MATCH(K4,$C$4:$C$13,0))","v":"Abby"},{"$f":"_xlfn.FORMULATEXT(L4)","v":"=INDEX($A$4:$A$13,MATCH(K4,$C$4:$C$13,0))"}]
["Betty",70,{"$f":"RANK(B5,$B$4:$B$13)","v":2},null,null,2,{"$f":"COUNTIF($C$4:$C$13,F5)","v":1},null,null,null,2,{"$f":"INDEX($A$4:$A$13,MATCH(K5,$C$4:$C$13,0))","v":"Betty"}]
["Claire",50,5,null,null,3,2,null,null,null,3,"Edie"]
["Della",40,6,null,null,4,0,null,null,null,4,{"$error":"#N/A"}]
["Edie",60,3,null,null,5,1,null,null,null,5,"Claire"]
["Flo",10,10,null,null,6,2,null,null,null,6,"Della"]
["Gloria",20,9,null,null,7,0,null,null,null,7,{"$error":"#N/A"}]
["Helen",60,3,null,null,8,1,null,null,null,8,"Jill"]
["Ivana",40,6,null,null,9,1,null,null,null,9,"Gloria"]
["Jill",30,8,null,null,10,1,null,null,null,10,"Flo"]

{"sheet":"RankCountIf","index":3,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["To make sure that the Rank function works, add the COUNTIF function"]
[]
["Name","Score","Rank",null,null,"How many people are ranked #",null,null,null,null,"Sort with a Formula"]
["Abby",80,{"$f":"RANK(B4,$B$4:$B$13)+COUNTIF(B$3:B3,B4)","v":1},{"$f":"_xlfn.FORMULATEXT(C4)","v":"=RANK(B4,$B$4:$B$13)+COUNTIF(B$3:B3,B4)"},null,1,{"$f":"COUNTIF($C$4:$C$13,F4)","v":1},{"$f":"_xlfn.FORMULATEXT(G4)","v":"=COUNTIF($C$4:$C$13,F4)"},null,null,1,{"$f":"INDEX($A$4:$A$13,MATCH(K4,$C$4:$C$13,0))","v":"Abby"},{"$f":"_xlfn.FORMULATEXT(L4)","v":"=INDEX($A$4:$A$13,MATCH(K4,$C$4:$C$13,0))"}]
["Betty",70,{"$f":"RANK(B5,$B$4:$B$13)+COUNTIF(B$3:B4,B5)","v":2},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=RANK(B5,$B$4:$B$13)+COUNTIF(B$3:B4,B5)"},null,2,{"$f":"COUNTIF($C$4:$C$13,F5)","v":1},null,null,null,2,{"$f":"INDEX($A$4:$A$13,MATCH(K5,$C$4:$C$13,0))","v":"Betty"}]
["Claire",50,{"$f":"RANK(B6,$B$4:$B$13)+COUNTIF(B$3:B5,B6)","v":5},"=RANK(B6,$B$4:$B$13)+COUNTIF(B$3:B5,B6)",null,3,1,null,null,null,3,"Edie"]
["Della",40,{"$f":"RANK(B7,$B$4:$B$13)+COUNTIF(B$3:B6,B7)","v":6},"=RANK(B7,$B$4:$B$13)+COUNTIF(B$3:B6,B7)",null,4,1,null,null,null,4,"Helen"]
["Edie",60,{"$f":"RANK(B8,$B$4:$B$13)+COUNTIF(B$3:B7,B8)","v":3},"=RANK(B8,$B$4:$B$13)+COUNTIF(B$3:B7,B8)",null,5,1,null,null,null,5,"Claire"]
["Flo",10,{"$f":"RANK(B9,$B$4:$B$13)+COUNTIF(B$3:B8,B9)","v":10},"=RANK(B9,$B$4:$B$13)+COUNTIF(B$3:B8,B9)",null,6,1,null,null,null,6,"Della"]
["Gloria",20,{"$f":"RANK(B10,$B$4:$B$13)+COUNTIF(B$3:B9,B10)","v":9},"=RANK(B10,$B$4:$B$13)+COUNTIF(B$3:B9,B10)",null,7,1,null,null,null,7,"Ivana"]
["Helen",60,{"$f":"RANK(B11,$B$4:$B$13)+COUNTIF(B$3:B10,B11)","v":4},"=RANK(B11,$B$4:$B$13)+COUNTIF(B$3:B10,B11)",null,8,1,null,null,null,8,"Jill"]
["Ivana",40,{"$f":"RANK(B12,$B$4:$B$13)+COUNTIF(B$3:B11,B12)","v":7},"=RANK(B12,$B$4:$B$13)+COUNTIF(B$3:B11,B12)",null,9,1,null,null,null,9,"Gloria"]
["Jill",30,{"$f":"RANK(B13,$B$4:$B$13)+COUNTIF(B$3:B12,B13)","v":8},"=RANK(B13,$B$4:$B$13)+COUNTIF(B$3:B12,B13)",null,10,1,null,null,null,10,"Flo"]

{"sheet":"Mystery","index":4,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["To make sure that the Rank function works, add the COUNTIF function"]
[]
["Name","Score","Rank",null,null,"How many people are ranked #"]
["Abby",1.0049692301187552,{"$f":"RANK(B4,$B$4:$B$16)+COUNTIF(B$3:B3,B4)","v":11},{"$f":"_xlfn.FORMULATEXT(C4)","v":"=RANK(B4,$B$4:$B$16)+COUNTIF(B$3:B3,B4)"},null,1,{"$f":"COUNTIF($C$4:$C$16,F4)","v":1},{"$f":"_xlfn.FORMULATEXT(G4)","v":"=COUNTIF($C$4:$C$16,F4)"}]
["Betty",1.05,{"$f":"RANK(B5,$B$4:$B$16)+COUNTIF(B$3:B4,B5)","v":9},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=RANK(B5,$B$4:$B$16)+COUNTIF(B$3:B4,B5)"},null,2,{"$f":"COUNTIF($C$4:$C$16,F5)","v":1}]
["Claire",1.1499999999999999,{"$f":"RANK(B6,$B$4:$B$16)+COUNTIF(B$3:B5,B6)","v":5},"=RANK(B6,$B$4:$B$16)+COUNTIF(B$3:B5,B6)",null,3,1]
["Della",1.3,{"$f":"RANK(B7,$B$4:$B$16)+COUNTIF(B$3:B6,B7)","v":1},"=RANK(B7,$B$4:$B$16)+COUNTIF(B$3:B6,B7)",null,4,0]
["Edie",1.05,{"$f":"RANK(B8,$B$4:$B$16)+COUNTIF(B$3:B7,B8)","v":10},"=RANK(B8,$B$4:$B$16)+COUNTIF(B$3:B7,B8)",null,5,1]
["Flo",1.1499999999999999,{"$f":"RANK(B9,$B$4:$B$16)+COUNTIF(B$3:B8,B9)","v":6},"=RANK(B9,$B$4:$B$16)+COUNTIF(B$3:B8,B9)",null,6,1]
["Gloria",0.90089291616828138,{"$f":"RANK(B10,$B$4:$B$16)+COUNTIF(B$3:B9,B10)","v":13},"=RANK(B10,$B$4:$B$16)+COUNTIF(B$3:B9,B10)",null,7,2]
["Helen",1.24,{"$f":"RANK(B11,$B$4:$B$16)+COUNTIF(B$3:B10,B11)","v":3},"=RANK(B11,$B$4:$B$16)+COUNTIF(B$3:B10,B11)",null,8,1]
["Ivana",1.1499999999999999,{"$f":"RANK(B12,$B$4:$B$16)+COUNTIF(B$3:B11,B12)","v":7},"=RANK(B12,$B$4:$B$16)+COUNTIF(B$3:B11,B12)",null,9,1]
["Jill",1.0900000000000001,{"$f":"RANK(B13,$B$4:$B$16)+COUNTIF(B$3:B12,B13)","v":8},"=RANK(B13,$B$4:$B$16)+COUNTIF(B$3:B12,B13)",null,10,1]
["Karen",1.0008806822347494,{"$f":"RANK(B14,$B$4:$B$16)+COUNTIF(B$3:B13,B14)","v":12},"=RANK(B14,$B$4:$B$16)+COUNTIF(B$3:B13,B14)",null,11,1]
["Lucy",1.1500000000000001,{"$f":"RANK(B15,$B$4:$B$16)+COUNTIF(B$3:B14,B15)","v":7},"=RANK(B15,$B$4:$B$16)+COUNTIF(B$3:B14,B15)",null,12,1]
["Mary",1.3,{"$f":"RANK(B16,$B$4:$B$16)+COUNTIF(B$3:B15,B16)","v":2},"=RANK(B16,$B$4:$B$16)+COUNTIF(B$3:B15,B16)",null,13,1]

{"sheet":"Why","index":5,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["To make sure that the Rank function works, add the COUNTIF function"]
[]
["Name","Score","Rank",null,null,"How many people are ranked #",null,null,null,null,null,"Name","Score"]
["Abby",1.0049692301187552,{"$f":"RANK(B4,$B$4:$B$16)+COUNTIF(B$3:B3,B4)","v":11},{"$f":"_xlfn.FORMULATEXT(C4)","v":"=RANK(B4,$B$4:$B$16)+COUNTIF(B$3:B3,B4)"},null,1,{"$f":"COUNTIF($C$4:$C$16,F4)","v":1},{"$f":"_xlfn.FORMULATEXT(G4)","v":"=COUNTIF($C$4:$C$16,F4)"},null,null,null,"Della",1.3]
["Betty",1.05,{"$f":"RANK(B5,$B$4:$B$16)+COUNTIF(B$3:B4,B5)","v":9},null,null,2,{"$f":"COUNTIF($C$4:$C$16,F5)","v":1},null,null,null,null,"Mary",1.3]
["Claire",1.1499999999999999,{"$f":"RANK(B6,$B$4:$B$16)+COUNTIF(B$3:B5,B6)","v":5},{"$f":"B6=B9","v":true},null,3,1,null,null,null,null,"Helen",1.24]
["Della",1.3,{"$f":"RANK(B7,$B$4:$B$16)+COUNTIF(B$3:B6,B7)","v":1},null,null,4,0,null,null,null,null,"Lucy",1.1500000000000001]
["Edie",1.05,{"$f":"RANK(B8,$B$4:$B$16)+COUNTIF(B$3:B7,B8)","v":10},null,null,5,1,null,null,null,null,"Claire",1.1499999999999999]
["Flo",1.1499999999999999,{"$f":"RANK(B9,$B$4:$B$16)+COUNTIF(B$3:B8,B9)","v":6},{"$f":"B9=B12","v":true},null,6,1,null,null,null,null,"Flo",1.1499999999999999]
["Gloria",0.90089291616828138,{"$f":"RANK(B10,$B$4:$B$16)+COUNTIF(B$3:B9,B10)","v":13},null,null,7,2,null,null,null,null,"Ivana",1.1499999999999999]
["Helen",1.24,{"$f":"RANK(B11,$B$4:$B$16)+COUNTIF(B$3:B10,B11)","v":3},null,null,8,1,null,null,null,null,"Jill",1.0900000000000001]
["Ivana",1.1499999999999999,{"$f":"RANK(B12,$B$4:$B$16)+COUNTIF(B$3:B11,B12)","v":7},{"$f":"(B12=B15)","v":true},null,9,1,null,null,null,null,"Betty",1.05]
["Jill",1.0900000000000001,{"$f":"RANK(B13,$B$4:$B$16)+COUNTIF(B$3:B12,B13)","v":8},null,null,10,1,null,null,null,null,"Edie",1.05]
["Karen",1.0008806822347494,{"$f":"RANK(B14,$B$4:$B$16)+COUNTIF(B$3:B13,B14)","v":12},null,null,11,1,null,null,null,null,"Abby",1.0049692301187552]
["Lucy",1.1500000000000001,{"$f":"RANK(B15,$B$4:$B$16)+COUNTIF(B$3:B14,B15)","v":7},{"$f":"(B15=B6)","v":true},null,12,1,null,null,null,null,"Karen",1.0008806822347494]
["Mary",1.3,{"$f":"RANK(B16,$B$4:$B$16)+COUNTIF(B$3:B15,B16)","v":2},null,null,13,1,null,null,null,null,"Gloria",0.90089291616828138]

{"sheet":"LookInTheXML","index":6,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"1 2345678901234567"]
[null,null,null,null,null,null,null,null,null,null,"1.1499999999999999"]
[]
[null,null,null,null,null,null,null,null,null,null,"1 2345678901234567"]
[null,null,null,null,null,null,null,null,null,null,"1.1500000000000001"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"15 digits","COUNTIF, equality tests"]
[]
[null,null,null,null,null,null,null,null,null,null,"17 digits","RANK, sorting"]

{"sheet":"Workaround","index":7,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["To make sure that the Rank function works, add the COUNTIF function"]
[]
["Name",null,"Score","Rank",null,null,"How many people are ranked #"]
["Abby",1.0049692301187552,{"$f":"ROUND(B4,14)","v":1.00496923011876},{"$f":"RANK(C4,$C$4:$C$16)+COUNTIF(C$3:C3,C4)","v":11},{"$f":"_xlfn.FORMULATEXT(D4)","v":"=RANK(C4,$C$4:$C$16)+COUNTIF(C$3:C3,C4)"},null,1,{"$f":"COUNTIF($D$4:$D$16,G4)","v":1},{"$f":"_xlfn.FORMULATEXT(H4)","v":"=COUNTIF($D$4:$D$16,G4)"}]
["Betty",1.05,{"$f":"ROUND(B5,14)","v":1.05},{"$f":"RANK(C5,$C$4:$C$16)+COUNTIF(C$3:C4,C5)","v":9},null,null,2,{"$f":"COUNTIF($D$4:$D$16,G5)","v":1}]
["Claire",1.1499999999999999,1.1499999999999999,{"$f":"RANK(C6,$C$4:$C$16)+COUNTIF(C$3:C5,C6)","v":4},{"$f":"C6=C9","v":true},null,3,1]
["Della",1.3,1.3,{"$f":"RANK(C7,$C$4:$C$16)+COUNTIF(C$3:C6,C7)","v":1},null,null,4,1]
["Edie",1.05,1.05,{"$f":"RANK(C8,$C$4:$C$16)+COUNTIF(C$3:C7,C8)","v":10},null,null,5,1]
["Flo",1.1499999999999999,1.1499999999999999,{"$f":"RANK(C9,$C$4:$C$16)+COUNTIF(C$3:C8,C9)","v":5},{"$f":"C9=C12","v":true},null,6,1]
["Gloria",0.90089291616828138,0.90089291616828004,{"$f":"RANK(C10,$C$4:$C$16)+COUNTIF(C$3:C9,C10)","v":13},null,null,7,1]
["Helen",1.24,1.24,{"$f":"RANK(C11,$C$4:$C$16)+COUNTIF(C$3:C10,C11)","v":3},null,null,8,1]
["Ivana",1.1499999999999999,1.1499999999999999,{"$f":"RANK(C12,$C$4:$C$16)+COUNTIF(C$3:C11,C12)","v":6},{"$f":"C12=C15","v":true},null,9,1]
["Jill",1.0900000000000001,1.0900000000000001,{"$f":"RANK(C13,$C$4:$C$16)+COUNTIF(C$3:C12,C13)","v":8},null,null,10,1]
["Karen",1.0008806822347494,1.00088068223475,{"$f":"RANK(C14,$C$4:$C$16)+COUNTIF(C$3:C13,C14)","v":12},null,null,11,1]
["Lucy",1.1500000000000001,1.1499999999999999,{"$f":"RANK(C15,$C$4:$C$16)+COUNTIF(C$3:C14,C15)","v":7},{"$f":"C15=C6","v":true},null,12,1]
["Mary",1.3,1.3,{"$f":"RANK(C16,$C$4:$C$16)+COUNTIF(C$3:C15,C16)","v":2},null,null,13,1]

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