Ham excel

Formulas For Ranking Data And Scores
"By Chip Pearson, www.cpearson.com"

Simple Ranks
Data Rank Unique Rank Reverse Rank Reverse Unique Rank
22 6 6 3 5
11 9 9 1 2
33 4 4 6 7
44 3 3 8 8
22 6 7 3 4
55 2 2 9 9
11 9 10 1 1
22 6 8 3 3
33 4 5 6 6
66 1 1 10 10

Count 6 10 6 10

"=RANK(C7,$C$7:$C$16)"
"=RANK(C7,C$7:C$16)+COUNTIF(C$7:C7,C7)-1"
"=RANK(C7,C$7:C$16,1)"
"=COUNT(C$7:C$16)-(RANK(C7,C$7:C$16)+COUNTIF(C$7:C7,C7))+2"


Ranking Player Scores
Player Score Unique Rank Player Rank
Annie 22 5 Gabriella
Barb 11 8 Faith
Cassie 33 3 Cassie
Darla 11 9 Kate
Emma 22 6 Annie
Faith 55 2 Emma
Gabriella 66 1 Hilly
Hilly 22 7 Barb
Janet 11 10 Darla
Kate 33 4 Janet

Count 5 10



"=RANK(D28,D$28:D$37)+COUNTIF(D$28:D28,D28)-1"

"=OFFSET(C$28,MATCH(SMALL(F$28:F$37,ROW()-ROW(H$28)+1),F$28:F$37,0)-1,0)"


"Ranking Player Scores, Reverse Order"
Player Score Reverse Unique Rank Reverse Player Rank
Annie 22 6 Janet
Barb 11 3 Darla
Cassie 33 8 Barb
Darla 11 2 Hilly
Emma 22 5 Emma
Faith 55 9 Annie
Gabriella 66 10 Kate
Hilly 22 4 Cassie
Janet 11 1 Faith
Kate 33 7 Gabriella

Count 5 10



"=COUNT(D$50:D$59)-(RANK(D50,D$50:D$59)+COUNTIF(D$50:D50,D50))+2"

"=OFFSET(C$50,MATCH(SMALL(F$50:F$59,ROW()-ROW(H$50)+1),F$50:F$59,0)-1,0)"