i am using the formula =RANK.EQ(C8, $C$8:$C$428) + COUNTIFS($C$8:$C$428, $C8, $D$8:$D$428, ">" & $D8) + COUNTIFS($C$8:$C$428, $C8, $D$8:$D$428, $D8, $E$8:$E$428, ">" & $E8) in Excel, but it is not ranking the values as expected. It does not seem to rank the data correctly in descending order as I intend. Could anyone help explain why this formula isn't working as intended and how I can fix it?"
PRIZES | NUMBERS | POINTS |
1 | 172 | 64.13 |
1 | 172 | 75 |
1 | 172 | 34.783 |
1 | 172 | 85.87 |
2 | 336 | 104.39 |
3 | 555 | 156.89 |
3 | 555 | 260.42 |
2 | 383 | 95.175 |
1 | 172 | 75.543 |
2 | 391 | 99.889 |
1 | 172 | 46.196 |
1 | 172 | 9.7826 |
1 | 164 | 59.489 |
1 | 164 | 69.343 |
3 | 555 | 206.52 |
2 | 336 | 111.84 |
1 | 172 | 100 |
1 | 164 | 18.613 |
2 | 172 | 49.457 |
2 | 383 | 73.667 |
1 | 164 | 33.942 |
1 | 172 | 24.457 |
1 | 164 | 6.5693 |
1 | 172 | 42.391 |
1 | 164 | 5.8394 |
1 | 219 | 20.339 |
2 | 336 | 19.946 |
1 | 164 | 21.533 |
1 | 164 | 52.92 |
1 | 164 | 63.139 |
1 | 172 | 35.326 |
2 | 336 | 106.34 |
1 | 219 | 61.017 |
2 | 336 | 126.81 |
1 | 172 | 50.543 |
1 | 164 | 77.737 |
2 | 391 | 115.57 |
1 | 164 | 78.102 |
1 | 164 | 52.555 |
2 | 336 | 44.343 |
2 | 336 | 43.76 |
1 | 219 | 8.4746 |
1 | 164 | 29.562 |
2 | 336 | 93.141 |
2 | 391 | 28.648 |
1 | 164 | 42.701 |
1 | 164 | 35.401 |
3 | 555 | 181.53 |
2 | 391 | 190.26 |
1 | 164 | 55.109 |
1 | 164 | 56.569 |
1 | 164 | 59.124 |
1 | 219 | 17.797 |
1 | 164 | 89.781 |
2 | 391 | 123.14 |
1 | 164 | 17.518 |
1 | 164 | 89.416 |
2 | 391 | 172.55 |
1 | 219 | 32.203 |
1 | 164 | 71.898 |
1 | 164 | 23.358 |
2 | 391 | 77.837 |
1 | 172 | 54.348 |
3 | 555 | 133.47 |
1 | 172 | 50 |
3 | 555 | 292.42 |
2 | 383 | 85.661 |
1 | 172 | 23.913 |
1 | 164 | 68.248 |
3 | 555 | 58.751 |
3 | 555 | 71.866 |
1 | 172 | 46.739 |
2 | 391 | 81.494 |
2 | 336 | 70.72 |
1 | 172 | 22.826 |
2 | 336 | 82.867 |
1 | 172 | 27.174 |
1 | 172 | 15.217 |
1 | 164 | 51.46 |
2 | 336 | 71.688 |
1 | 172 | 71.196 |
1 | 219 | 1.6949 |
1 | 164 | 14.599 |
1 | 172 | 38.043 |
3 | 555 | 67.087 |
2 | 336 | 95.613 |
2 | 336 | 79.534 |
3 | 555 | 123.08 |
1 | 172 | 44.565 |
2 | 336 | 65.071 |
3 | 555 | 228.59 |
2 | 336 | 163.41 |
2 | 383 | 49.468 |
1 | 164 | 49.635 |
1 | 164 | 96.715 |
1 | 164 | 33.212 |
1 | 219 | 57.627 |
3 | 555 | 155.77 |
3 | 555 | 103.73 |
1 | 0 | 0 |
1 | 172 | 25.543 |
1 | 164 | 54.745 |
2 | 391 | 163.12 |
3 | 555 | 182.29 |
1 | 164 | 32.482 |
1 | 219 | 34.746 |
1 | 164 | 73.358 |
2 | 391 | 125.17 |
1 | 172 | 41.304 |
1 | 164 | 43.431 |
1 | 164 | 67.153 |
3 | 555 | 225.2 |
2 | 336 | 177.09 |
3 | 555 | 190.04 |
1 | 172 | 12.5 |
1 | 172 | 36.957 |
2 | 391 | 131.98 |
1 | 172 | 44.022 |
1 | 219 | 48.305 |
1 | 219 | 12.712 |
2 | 336 | 128.13 |
1 | 172 | 33.696 |
2 | 383 | 163.89 |
1 | 172 | 7.6087 |
1 | 172 | 92.391 |
1 | 172 | 15.761 |
3 | 555 | 131.52 |
1 | 219 | 33.898 |
1 | 219 | 35.593 |
1 | 172 | 67.935 |
1 | 219 | 49.153 |
1 | 172 | 76.087 |
3 | 555 | 236.14 |
2 | 336 | 77.991 |
1 | 164 | 86.861 |
1 | 164 | 18.978 |
1 | 172 | 77.174 |
1 | 164 | 27.007 |
2 | 336 | 153.61 |
2 | 336 | 96.553 |
1 | 164 | 63.869 |
1 | 164 | 71.168 |
1 | 172 | 34.239 |
1 | 172 | 76.63 |
2 | 391 | 108.16 |
1 | 172 | 19.022 |
2 | 391 | 133.78 |
1 | 219 | 77.119 |
1 | 164 | 76.277 |
2 | 383 | 99.474 |
1 | 172 | 32.065 |
2 | 383 | 99.431 |
1 | 172 | 41.848 |
1 | 172 | 72.826 |
3 | 555 | 98.282 |
1 | 164 | 63.504 |
1 | 219 | 16.102 |
3 | 555 | 250.81 |
1 | 172 | 60.87 |
2 | 391 | 167.45 |
2 | 336 | 149.57 |
1 | 219 | 52.542 |
2 | 383 | 77.156 |
3 | 555 | 231.05 |
1 | 164 | 45.985 |
1 | 172 | 69.022 |
1 | 172 | 35.87 |
1 | 219 | 58.475 |
1 | 172 | 61.413 |
2 | 336 | 137.08 |
2 | 383 | 172.7 |
1 | 164 | 97.81 |
3 | 555 | 224.4 |
1 | 164 | 26.642 |
1 | 164 | 24.818 |
1 | 172 | 80.435 |
1 | 219 | 98.305 |
1 | 172 | 5.9783 |
2 | 391 | 68.93 |
1 | 172 | 21.196 |
3 | 555 | 65.424 |
2 | 336 | 84.921 |
1 | 164 | 60.584 |
1 | 164 | 16.788 |
3 | 555 | 297.83 |
1 | 164 | 18.248 |
1 | 164 | 11.679 |
2 | 383 | 77.737 |
1 | 164 | 57.299 |
2 | 383 | 150.97 |
1 | 164 | 5.4745 |
1 | 164 | 65.328 |
1 | 172 | 59.239 |
2 | 336 | 136.41 |
1 | 164 | 94.891 |
2 | 383 | 92.02 |
2 | 383 | 89.484 |
2 | 391 | 73.904 |
1 | 172 | 3.8043 |
1 | 172 | 4.8913 |
1 | 172 | 65.761 |
1 | 172 | 9.2391 |
1 | 164 | 46.35 |
1 | 164 | 51.095 |
1 | 172 | 52.174 |
1 | 219 | 3.3898 |
1 | 219 | 60.169 |
1 | 219 | 55.085 |
1 | 219 | 62.712 |
1 | 219 | 30.508 |
1 | 164 | 94.526 |
1 | 164 | 61.314 |
1 | 164 | 81.387 |
1 | 172 | 77.717 |
1 | 172 | 59.783 |
2 | 383 | 156.56 |
1 | 164 | 88.686 |
1 | 164 | 28.102 |
1 | 219 | 26.271 |
2 | 383 | 45.676 |
2 | 383 | 138.79 |
2 | 383 | 110.28 |
1 | 164 | 55.839 |
1 | 164 | 65.693 |
1 | 219 | 6.7797 |
2 | 383 | 76.135 |
1 | 164 | 45.255 |
1 | 164 | 17.153 |
1 | 164 | 64.964 |
1 | 164 | 19.708 |
1 | 164 | 98.905 |
1 | 172 | 63.587 |
1 | 164 | 1.8248 |
2 | 336 | 74.123 |
3 | 555 | 179.32 |
2 | 336 | 117.82 |
1 | 164 | 27.372 |
1 | 164 | 91.971 |
1 | 164 | 31.752 |
2 | 336 | 144.3 |
2 | 336 | 95.565 |
2 | 336 | 101.42 |
1 | 164 | 6.9343 |
1 | 164 | 83.942 |
1 | 164 | 79.927 |
1 | 164 | 93.431 |
1 | 172 | 10.87 |
1 | 164 | 64.599 |
1 | 172 | 2.1739 |
1 | 172 | 5.4348 |
1 | 164 | 67.883 |
2 | 383 | 71.65 |
2 | 383 | 90.598 |
1 | 164 | 61.679 |
1 | 164 | 48.905 |
1 | 164 | 11.314 |
1 | 164 | 13.504 |
1 | 164 | 35.036 |
1 | 164 | 98.54 |
1 | 164 | 94.161 |
1 | 164 | 48.175 |
1 | 172 | 26.63 |
1 | 164 | 85.036 |
2 | 336 | 127.14 |
2 | 336 | 139.24 |
1 | 164 | 56.204 |
1 | 164 | 7.2993 |
1 | 164 | 82.847 |
3 | 555 | 273.76 |
1 | 164 | 50 |
1 | 164 | 79.562 |
1 | 172 | 33.152 |
1 | 219 | 14.407 |
2 | 391 | 102.99 |
1 | 219 | 66.949 |
2 | 383 | 109.26 |
2 | 391 | 48.462 |
1 | 172 | 8.6957 |
1 | 172 | 22.283 |
2 | 336 | 12.873 |
1 | 164 | 47.445 |
2 | 383 | 192.11 |
2 | 383 | 77.657 |
2 | 383 | 85.773 |
1 | 164 | 99.27 |
1 | 164 | 2.1898 |
1 | 164 | 78.832 |
2 | 391 | 91.203 |
2 | 383 | 114.64 |
1 | 164 | 86.496 |
1 | 164 | 47.81 |
1 | 219 | 88.983 |
1 | 164 | 81.752 |
2 | 336 | 110.9 |
1 | 172 | 84.783 |
1 | 164 | 93.796 |
2 | 383 | 100.27 |
1 | 172 | 4.3478 |
1 | 164 | 74.088 |
2 | 383 | 74.05 |
1 | 164 | 25.182 |
1 | 164 | 38.321 |
1 | 164 | 77.007 |
1 | 164 | 70.803 |
1 | 164 | 53.65 |
3 | 555 | 108.23 |
1 | 219 | 31.356 |
2 | 336 | 110.46 |
2 | 336 | 166.35 |
1 | 164 | 8.0292 |
2 | 336 | 140.79 |
1 | 164 | 83.212 |
1 | 172 | 14.13 |
1 | 164 | 15.693 |
1 | 164 | 51.825 |
1 | 172 | 66.848 |
1 | 219 | 96.61 |
1 | 164 | 14.234 |
1 | 164 | 41.971 |
1 | 172 | 66.304 |
1 | 172 | 40.217 |
1 | 164 | 91.241 |
2 | 336 | 64.61 |
1 | 164 | 24.453 |
1 | 172 | 20.652 |
2 | 336 | 47.719 |
1 | 164 | 68.978 |
1 | 172 | 28.261 |
1 | 164 | 13.139 |
1 | 164 | 2.9197 |
1 | 164 | 3.2847 |
1 | 164 | 5.1095 |
1 | 164 | 10.949 |
1 | 164 | 60.949 |
1 | 164 | 12.409 |
2 | 172 | 19.565 |
1 | 164 | 58.029 |
1 | 172 | 1.6304 |
1 | 164 | 50.73 |
1 | 164 | 82.117 |
1 | 164 | 73.723 |
1 | 164 | 4.0146 |
2 | 336 | 99.421 |
1 | 164 | 32.847 |
1 | 164 | 9.1241 |
1 | 164 | 22.628 |
1 | 172 | 94.022 |
1 | 164 | 53.285 |
1 | 164 | 37.591 |
1 | 164 | 30.657 |
1 | 164 | 20.438 |
2 | 383 | 136.27 |
1 | 164 | 77.372 |
1 | 219 | 28.814 |
1 | 164 | 58.394 |
1 | 219 | 23.729 |
1 | 219 | 42.373 |
1 | 172 | 28.804 |
1 | 164 | 16.058 |
1 | 172 | 47.826 |
2 | 336 | 115.16 |
2 | 336 | 62.948 |
1 | 164 | 25.547 |
1 | 164 | 71.533 |
1 | 164 | 44.891 |
1 | 164 | 69.708 |
1 | 172 | 32.609 |
1 | 172 | 39.674 |
2 | 336 | 61.096 |
1 | 164 | 59.854 |
1 | 164 | 58.759 |
1 | 172 | 3.2609 |
1 | 164 | 85.766 |
3 | 555 | 276.53 |
1 | 164 | 76.642 |
1 | 219 | 51.695 |
1 | 164 | 72.993 |
1 | 164 | 1.0949 |
1 | 164 | 38.686 |
1 | 164 | 62.044 |
1 | 172 | 13.043 |
1 | 219 | 43.22 |
3 | 555 | 289.08 |
1 | 164 | 79.197 |
1 | 164 | 64.234 |
1 | 164 | 83.577 |
1 | 164 | 80.657 |
2 | 391 | 99.714 |
1 | 164 | 21.168 |
1 | 219 | 74.576 |
1 | 172 | 7.0652 |
1 | 164 | 62.409 |
1 | 172 | 8.1522 |
1 | 172 | 6.5217 |
1 | 172 | 14.674 |
1 | 164 | 8.7591 |
1 | 164 | 25.912 |
1 | 164 | 40.876 |
1 | 164 | 43.796 |
1 | 164 | 56.934 |
2 | 383 | 190.52 |
1 | 172 | 68.478 |
1 | 164 | 23.723 |
1 | 164 | 47.08 |
1 | 164 | 35.766 |
1 | 164 | 66.058 |
1 | 219 | 5.0847 |
2 | 336 | 81.577 |
2 | 391 | 127.76 |
3 | 555 | 242.49 |
1 | 172 | 63.043 |
1 | 164 | 9.4891 |
1 | 164 | 62.774 |
1 | 164 | 84.672 |
1 | 164 | 70.073 |
1 | 164 | 48.54 |
1 | 172 | 2.7174 |
2 | 336 | 54.292 |
1 | 164 | 36.496 |
1 | 164 | 86.131 |