Spreadsheet: 123356d1317602846-how-to-display-1st-2nd-3rd-referring-to-rank-sampler
Sheet: Over-all ranking

formula to automatically display 1st, second,3rd, referring to the rank in cell N14
if there is a duplicate rank
 | SCHOLASTIC ( A ) |  |  |  |  |  |  | CO - CURRICULAR ( B )
NAMES |  | RANK | WT | WT   RANK - A |  | TOTAL |  | RANK | WT | WT   RANK - B |  | TOTAL WT-RANK   ( A + B ) | FINAL RANKING | OVERALL RANKING
 | AVE GRADE |  |  |  |  | POINTS
0 | #N/A | 1 | 9 | 9 |  | #N/A |  | 1 | 1 | 1 |  | 10 | 1 | 1st HONORS | should be like this
0 | #N/A | 2 | 9 | 18 |  | #N/A |  | 17 | 1 | 17 |  | 35 | 3 | 3RD HONORS
0 | #N/A | 3 | 9 | 27 |  | #N/A |  | 7 | 1 | 7 |  | 34 | 2 | 2ND HONORS
0 | #N/A | 4 | 9 | 36 |  | #N/A |  | 9 | 1 | 3 |  | 39 | 2 | COMMENDABLE
0 | #N/A | 5 | 9 | 45 |  | #N/A |  | 6 | 1 | 6 |  | 51 | 5 | COMMENDABLE
0 | #N/A | 6 | 9 | 54 |  | #N/A |  | 2 | 1 | 2 |  | 56 | 6 | COMMENDABLE
0 | #N/A | 7 | 9 | 63 |  | #N/A |  | 4 | 1 | 4 |  | 67 | 7 | COMMENDABLE
0 | #N/A | 8 | 9 | 72 |  | #N/A |  | 26.5 | 1 | 26.5 |  | 98.5 | 8.5 | COMMENDABLE
0 | #N/A | 9 | 9 | 81 |  | #N/A |  | 24 | 1 | 24 |  | 98.5 | 8.5 | COMMENDABLE
0 | #N/A | 10 | 9 | 90 |  | #N/A |  | 18 | 1 | 18 |  | 108 | 11 | COMMENDABLE
0 | #N/A | 11 | 9 | 99 |  | #N/A |  | 3 | 1 | 3 |  | 102 | 10 | COMMENDABLE
0 | #N/A | 12 | 9 | 108 |  | #N/A |  | 5 | 1 | 5 |  | 113 | 12 | COMMENDABLE
0 | #N/A | 13 | 9 | 117 |  | #N/A |  | 19 | 1 | 19 |  | 136 | 13 | COMMENDABLE
0 | #N/A | 14 | 9 | 126 |  | #N/A |  | 25 | 1 | 25 |  | 151 | 14 | COMMENDABLE
0 | #N/A | 15 | 9 | 135 |  | #N/A |  | 28 | 1 | 28 |  | 163 | 16 | COMMENDABLE
0 | #N/A | 16 | 9 | 144 |  | #N/A |  | 15 | 1 | 15 |  | 159 | 15 | COMMENDABLE
0 | #N/A | 17 | 9 | 153 |  | #N/A |  | 20.5 | 1 | 20.5 |  | 173.5 | 18 | COMMENDABLE
0 | #N/A | 18 | 9 | 162 |  | #N/A |  | 10 | 1 | 10 |  | 172 | 17 | COMMENDABLE
0 | #N/A | 19 | 9 | 171 |  | #N/A |  | 16 | 1 | 16 |  | 187 | 19 | COMMENDABLE
0 | #N/A | 20 | 9 | 180 |  | #N/A |  | 23 | 1 | 23 |  | 203 | 20 | COMMENDABLE
0 | #N/A | 21 | 9 | 189 |  | #N/A |  | 22 | 1 | 22 |  | 211 | 34.5 | COMMENDABLE
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5 | COMMENDABLE
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
0 | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
#N/A | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
#N/A | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
#N/A | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
#N/A | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5
#N/A | #N/A | 22 | 9 | 198 |  | #N/A |  | 13 | 1 | 13 |  | 211 | 34.5