I have figured out how to create a rank based on individual values but what I am trying to do is create an overall rank based on the individual ranks. I know there is RANK.AVG formula however it only gives the average for the rank rather than an actual rank. Is there anyway to get a complete average so to speak?
Example:
<tbody>
</tbody>
Hopefully the example helps show what I am looking for.
Example:
Quality | Rank | Tracking | Rank | Index | Rank | Overall Rank | |
100 | 1 | 85 | 3 | 102 | 1 | 1 | |
87 | 5 | 80.5 | 4 | 88 | 4 | 3 | |
90 | 3 | 53 | 9 | 89 | 3 | 2 | |
85 | 6 | 69 | 8 | 97 | 2 | 4 | |
100 | 1 | 91.67 | 2 | 78 | 6 | 6 | |
90 | 3 | 70 | 6 | 82 | 5 | 5 |
<tbody>
</tbody>
Hopefully the example helps show what I am looking for.