I am trying to rank values in a table that has duplicate names:
<tbody>
</tbody>
The output should look like this:
<tbody>
</tbody>
Is there a clever way to do it instead of going through another table that takes the minimum/average for each unique 'Code' and then ranking these?
Thank you!
Code | Var1 |
123 | 1 |
123 | 1.5 |
222 | 3 |
222 | 3.5 |
222 | 4 |
333 | 1 |
333 | 2 |
<tbody>
</tbody>
The output should look like this:
Code | Rank |
123 | 1 |
222 | 3 |
333 | 2 |
<tbody>
</tbody>
Is there a clever way to do it instead of going through another table that takes the minimum/average for each unique 'Code' and then ranking these?
Thank you!