I have the following data set with a list of players and their contribution to the group they belong.

I've calculated the % of the player contribution within his/her group in "% Player Contribution Within Group":

```
=[@[Player Contribution]]/SUMIF([Group];[@Group];[Player Contribution])
```

Then I've calculated the ranking of that % contribution in "Player Contribution's Rank Within Group"

```
=COUNTIFS([Group];[@Group];[% Player Contribution Within Group];">"&D2)+1
```

Since the % contribution's may vary a lot between players (is very evident for Group B), to show this difference (for instance) between the first player of Group B (84,97%) and the second and third (less than 8%) of the same group, I would like to calculate a sort of "weighted ranking" (it it makes sense .. not quite sure). Is there a way (a formula) to express with the result of a calculation this kind of difference?

Thanks a lot in advance.