{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Samples"],"not_rendered":{"charts":0,"images":0,"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":"Samples","index":0,"n_rows":59,"n_cols":15,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["Input"]
[4,5,6]
[5,4,6]
[4,4,6]
[1,2,3]
[]
["Normal Rank {=RANK(A2:C5,A2:C5)}"]
[{"$f":"RANK(A2:C5,A2:C5)","v":6},4,1]
[4,6,1]
[6,6,1]
[12,11,10]
[]
["sbUniqRank {=sbUniqRank(A2:C5,1)}",null,null,null,"Unique Rank with Worksheet Functions",null,null,null,"Josef's Suggestion",null,null,null,"sbUniqRank {=sbUniqRank(A2:C5,1)}"]
[{"$f":"sbUniqRank($A$2:$C$5,1,FALSE,1)","v":4},8,10,null,{"$f":"COUNTIF(Input,\">\"&A2)+IFERROR(COUNTIF(OFFSET(Input,0,0,ROW(A2)-ROW(Input),COLUMNS(Input)),A2),0)+IFERROR(COUNTIF(OFFSET(Input,ROW(A2)-ROW(Input),0,1,COLUMN(A2)-COLUMN(Input)+1),A2),0)","v":6},4,1,null,{"$f":"RANK(A2,$A$2:$C$5,0)+COUNTIF($A$1:$C1,A2)+COUNTIF($A2:A2,A2)-1","v":6},{"$f":"RANK(B2,$A$2:$C$5,0)+COUNTIF($A$1:$C1,B2)+COUNTIF($A2:B2,B2)-1","v":4},{"$f":"RANK(C2,$A$2:$C$5,0)+COUNTIF($A$1:$C1,C2)+COUNTIF($A2:C2,C2)-1","v":1},null,4,8,10]
[9,5,11,null,5,7,2,null,{"$f":"RANK(A3,$A$2:$C$5,0)+COUNTIF($A$1:$C2,A3)+COUNTIF($A3:A3,A3)-1","v":5},{"$f":"RANK(B3,$A$2:$C$5,0)+COUNTIF($A$1:$C2,B3)+COUNTIF($A3:B3,B3)-1","v":7},{"$f":"RANK(C3,$A$2:$C$5,0)+COUNTIF($A$1:$C2,C3)+COUNTIF($A3:C3,C3)-1","v":2},null,9,5,11]
[6,7,12,null,8,9,3,null,{"$f":"RANK(A4,$A$2:$C$5,0)+COUNTIF($A$1:$C3,A4)+COUNTIF($A4:A4,A4)-1","v":8},{"$f":"RANK(B4,$A$2:$C$5,0)+COUNTIF($A$1:$C3,B4)+COUNTIF($A4:B4,B4)-1","v":9},{"$f":"RANK(C4,$A$2:$C$5,0)+COUNTIF($A$1:$C3,C4)+COUNTIF($A4:C4,C4)-1","v":3},null,6,7,12]
[1,2,3,null,12,11,10,null,{"$f":"RANK(A5,$A$2:$C$5,0)+COUNTIF($A$1:$C4,A5)+COUNTIF($A5:A5,A5)-1","v":12},{"$f":"RANK(B5,$A$2:$C$5,0)+COUNTIF($A$1:$C4,B5)+COUNTIF($A5:B5,B5)-1","v":11},{"$f":"RANK(C5,$A$2:$C$5,0)+COUNTIF($A$1:$C4,C5)+COUNTIF($A5:C5,C5)-1","v":10},null,1,2,3]
[]
["sbUniqRank {=sbUniqRank(A2:C5,2)}"]
[{"$f":"sbUniqRank($A$2:$C$5,2)","v":6},4,1]
[5,7,2]
[9,8,3]
[12,11,10]
[]
["sbUniqRank {=sbUniqRank(A2:C5,3)}"]
[{"$f":"sbUniqRank($A$2:$C$5,3)","v":9},5,3]
[4,8,2]
[6,7,1]
[12,11,10]
[]
["sbUniqRank {=sbUniqRank(A2:C5,4)}"]
[{"$f":"sbUniqRank($A$2:$C$5,4)","v":9},5,3]
[4,8,2]
[7,6,1]
[12,11,10]
[]
["sbUniqRank {=sbUniqRank(A2:C5,5)}"]
[{"$f":"sbUniqRank($A$2:$C$5,5)","v":6},5,1]
[4,8,2]
[7,9,3]
[12,11,10]
[]
["sbUniqRank {=sbUniqRank(A2:C5,6)}"]
[{"$f":"sbUniqRank($A$2:$C$5,6)","v":7},5,3]
[4,9,2]
[6,8,1]
[12,11,10]
[]
["sbUniqRank {=sbUniqRank(A2:C5,7)}"]
[{"$f":"sbUniqRank($A$2:$C$5,7)","v":8},4,1]
[5,6,2]
[9,7,3]
[12,11,10]
[]
["sbUniqRank {=sbUniqRank(A2:C5,8)}"]
[{"$f":"sbUniqRank($A$2:$C$5,8)","v":9},4,3]
[5,7,2]
[8,6,1]
[12,11,10]