I need help I'm trying to do a ranking on the score in column A, but it keeps coming back with duplicates. Any help would greatly be appreciated. Here is a copy of the data I'm trying to rank. The formula built in the rank column is =RANK(A2,$A$2:$A$105)+COUNTIF($A$2:A2,A2)-1.
<colgroup><col style="width: 33pt; mso-width-source: userset; mso-width-alt: 1609;" width="44"> <col style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" width="55"> <col style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;" width="78"> <col style="width: 44pt; mso-width-source: userset; mso-width-alt: 2121;" width="58"> <col style="width: 32pt; mso-width-source: userset; mso-width-alt: 1572;" width="43"> <col style="width: 33pt; mso-width-source: userset; mso-width-alt: 1609;" span="3" width="44"> <col style="width: 36pt; mso-width-source: userset; mso-width-alt: 1755;" width="48"> <tbody>
</tbody>
| Score | Rework Score | HC Attempt Score | HC Pass Score | HIC % | OTG Score | VOC Score | UPTX Score | Rank |
| 4.35 | 5 | 5 | 5 | 2 | 5 | 5 | 5 | 1 |
| 4.30 | 5 | 4 | 4 | 5 | 5 | 5 | 5 | 4 |
| 4.30 | 5 | 5 | 5 | 3 | 5 | 4 | 5 | 3 |
| 4.30 | 5 | 5 | 5 | 2 | 4 | 5 | 5 | 6 |
| 4.30 | 5 | 5 | 5 | 3 | 3 | 5 | 5 | 5 |
| 4.25 | 5 | 5 | 5 | 1 | 4 | 5 | 5 | 7 |
| 4.25 | 5 | 5 | 5 | 4 | 1 | 5 | 5 | 8 |
| 4.30 | 5 | 5 | 5 | 2 | 4 | 5 | 5 | 8 |
| 4.25 | 5 | 5 | 5 | 2 | 3 | 5 | 5 | 9 |
| 4.25 | 5 | 4 | 5 | 1 | 5 | 5 | 5 | 10 |
| 4.15 | 4 | 5 | 5 | 3 | 5 | 5 | 5 | 11 |
| 4.15 | 5 | 5 | 4 | 1 | 5 | 5 | 5 | 13 |
| 4.10 | 5 | 5 | 5 | 5 | 5 | 1 | 5 | 14 |
| 4.10 | 5 | 5 | 5 | 3 | 5 | 2 | 5 | 14 |
| 4.05 | 5 | 5 | 5 | 2 | 4 | 5 | 4 | 15 |
| 4.05 | 4 | 5 | 5 | 1 | 5 | 5 | 5 | 16 |
| 4.05 | 4 | 5 | 5 | 1 | 5 | 5 | 5 | 17 |
| 4.00 | 4 | 4 | 5 | 1 | 5 | 5 | 5 | 18 |
| 4.00 | 4 | 5 | 4 | 3 | 5 | 5 | 5 | 19 |
| 4.00 | 5 | 5 | 5 | 2 | 3 | 5 | 4 | 20 |
| 4.00 | 5 | 5 | 5 | 3 | 3 | 2 | 5 | 21 |
| 3.95 | 5 | 4 | 5 | 2 | 4 | 2 | 5 | 22 |
| 3.95 | 4 | 5 | 4 | 3 | 4 | 5 | 5 | 24 |
| 3.90 | 4 | 4 | 4 | 5 | 2 | 5 | 5 | 25 |
| 3.90 | 4 | 4 | 5 | 4 | 5 | 5 | 4 | 25 |
| 3.85 | 4 | 5 | 5 | 2 | 5 | 5 | 4 | 27 |
| 3.90 | 5 | 5 | 5 | 1 | 5 | 1 | 5 | 27 |
| 3.85 | 5 | 5 | 5 | 1 | 4 | 1 | 5 | 28 |
| 3.85 | 3 | 5 | 5 | 2 | 5 | 5 | 5 | 29 |
| 3.80 | 5 | 4 | 4 | 5 | 3 | 1 | 5 | 31 |
| 3.80 | 5 | 5 | 5 | 1 | 5 | 5 | 3 | 32 |
| 3.75 | 5 | 5 | 5 | 5 | 5 | 5 | 2 | 33 |
| 3.85 | 4 | 3 | 5 | 1 | 3 | 5 | 5 | 33 |
| 3.75 | 5 | 5 | 3 | 3 | 5 | 4 | 4 | 34 |
| 3.70 | 4 | 4 | 5 | 3 | 3 | 2 | 5 | 35 |
| 3.70 | 4 | 5 | 5 | 4 | 5 | 5 | 3 | 36 |
| 3.65 | 4 | 5 | 5 | 1 | 2 | 5 | 4 | 38 |
| 3.70 | 4 | 4 | 5 | 1 | 4 | 5 | 4 | 39 |
| 3.65 | 5 | 3 | 4 | 1 | 2 | 5 | 4 | 39 |
| 3.65 | 2 | 5 | 5 | 3 | 5 | 5 | 5 | 40 |
| 3.65 | 5 | 3 | 5 | 1 | 4 | 5 | 3 | 41 |
| 3.65 | 4 | 5 | 5 | 1 | 5 | 1 | 5 | 42 |
| 3.60 | 5 | 2 | 4 | 3 | 2 | 4 | 4 | 43 |
| 3.60 | 2 | 5 | 5 | 2 | 5 | 5 | 5 | 44 |
| 3.50 | 5 | 5 | 5 | 3 | 5 | 1 | 3 | 45 |
| 3.45 | 3 | 5 | 5 | 2 | 5 | 1 | 5 | 46 |
| 3.45 | 5 | 4 | 5 | 1 | 4 | 5 | 2 | 47 |
| 3.40 | 5 | 5 | 4 | 4 | 5 | 1 | 3 | 48 |
| 3.40 | 4 | 2 | 2 | 2 | 3 | 5 | 5 | 49 |
| 3.40 | 5 | 5 | 4 | 1 | 5 | 5 | 2 | 52 |
| 3.35 | 5 | 5 | 3 | 2 | 1 | 5 | 3 | 52 |
| 3.40 | 1 | 5 | 5 | 3 | 5 | 5 | 5 | 53 |
| 3.35 | 4 | 4 | 2 | 2 | 5 | 5 | 4 | 53 |
| 3.35 | 5 | 5 | 3 | 3 | 5 | 5 | 2 | 54 |
| 3.30 | 3 | 4 | 5 | 2 | 3 | 1 | 5 | 55 |
| 3.30 | 3 | 5 | 5 | 1 | 5 | 5 | 3 | 57 |
| 3.25 | 5 | 4 | 5 | 1 | 5 | 5 | 1 | 57 |
| 3.25 | 2 | 5 | 5 | 1 | 5 | 2 | 5 | 58 |
| 3.20 | 4 | 3 | 3 | 2 | 5 | 5 | 3 | 60 |
| 3.20 | 5 | 5 | 5 | 2 | 2 | 5 | 1 | 60 |
| 3.15 | 4 | 5 | 5 | 1 | 5 | 1 | 3 | 62 |
| 3.15 | 1 | 5 | 5 | 4 | 3 | 3 | 5 | 62 |
| 3.10 | 1 | 5 | 5 | 5 | 5 | 1 | 5 | 63 |
| 3.10 | 1 | 4 | 5 | 2 | 1 | 5 | 5 | 64 |
| 3.10 | 5 | 4 | 4 | 1 | 5 | 5 | 1 | 68 |
| 3.10 | 1 | 5 | 3 | 3 | 5 | 5 | 5 | 66 |
| 3.05 | 1 | 4 | 3 | 4 | 4 | 5 | 5 | 68 |
| 3.05 | 5 | 5 | 5 | 4 | 5 | 1 | 1 | 68 |
| 3.00 | 4 | 2 | 5 | 4 | 2 | 1 | 3 | 69 |
| 3.00 | 3 | 1 | 5 | 1 | 1 | 1 | 5 | 71 |
| 2.95 | 1 | 4 | 5 | 3 | 2 | 5 | 4 | 71 |
| 2.90 | 1 | 4 | 5 | 2 | 2 | 5 | 4 | 72 |
| 2.85 | 2 | 5 | 3 | 4 | 2 | 1 | 5 | 73 |
| 2.80 | 2 | 4 | 5 | 1 | 2 | 2 | 4 | 75 |
| 2.80 | 1 | 4 | 5 | 4 | 1 | 1 | 5 | 75 |
| 2.75 | 1 | 4 | 5 | 1 | 5 | 5 | 3 | 76 |
| 2.75 | 1 | 5 | 5 | 3 | 5 | 1 | 4 | 77 |
| 2.70 | 4 | 4 | 2 | 4 | 4 | 3 | 2 | 78 |
| 2.65 | 3 | 4 | 3 | 3 | 5 | 1 | 3 | 79 |
| 2.65 | 1 | 4 | 5 | 1 | 3 | 5 | 3 | 80 |
| 2.45 | 1 | 4 | 5 | 1 | 2 | 1 | 4 | 81 |
| 2.45 | 2 | 5 | 5 | 3 | 1 | 5 | 1 | 83 |
| 2.40 | 1 | 5 | 5 | 3 | 3 | 1 | 3 | 84 |
| 2.40 | 1 | 4 | 4 | 2 | 3 | 1 | 4 | 84 |
| 2.40 | 1 | 3 | 3 | 1 | 3 | 1 | 5 | 86 |
| 2.40 | 4 | 4 | 2 | 2 | 4 | 1 | 2 | 87 |
| 2.35 | 1 | 5 | 5 | 3 | 2 | 1 | 3 | 88 |
| 2.40 | 3 | 5 | 4 | 1 | 3 | 1 | 2 | 88 |
| 2.20 | 2 | 3 | 5 | 1 | 3 | 1 | 2 | 89 |
| 2.10 | 4 | 1 | 4 | 1 | 1 | 1 | 1 | 90 |
| 2.00 | 1 | 1 | 5 | 3 | 1 | 5 | 1 | 91 |
| 1.90 | 5 | 1 | 1 | 1 | 1 | 1 | 1 | 92 |
| 1.90 | 5 | 1 | 1 | 1 | 1 | 1 | 1 | 93 |
| 1.90 | 5 | 1 | 1 | 1 | 1 | 1 | 1 | 94 |
| 1.90 | 5 | 1 | 1 | 1 | 1 | 1 | 1 | 95 |
| 1.90 | 5 | 1 | 1 | 1 | 1 | 1 | 1 | 96 |
| 1.90 | 5 | 1 | 1 | 1 | 1 | 1 | 1 | 97 |
| 1.90 | 5 | 1 | 1 | 1 | 1 | 1 | 1 | 98 |
| 1.90 | 5 | 1 | 1 | 1 | 1 | 1 | 1 | 99 |
| 0.90 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 100 |
| 0.90 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 101 |
| 0.90 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 102 |
| 0.90 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 103 |
| 0.90 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 104 |
<colgroup><col style="width: 33pt; mso-width-source: userset; mso-width-alt: 1609;" width="44"> <col style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" width="55"> <col style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;" width="78"> <col style="width: 44pt; mso-width-source: userset; mso-width-alt: 2121;" width="58"> <col style="width: 32pt; mso-width-source: userset; mso-width-alt: 1572;" width="43"> <col style="width: 33pt; mso-width-source: userset; mso-width-alt: 1609;" span="3" width="44"> <col style="width: 36pt; mso-width-source: userset; mso-width-alt: 1755;" width="48"> <tbody>
</tbody>
