Automatically sort the data and ranking based on the sorted data

Hi,
In the attached spreadsheet I track the performance of my team. I enter the AHT for my team in the work sheet named "AHT Summary".I keep updating this data every month. I need your help to automatically sort the updated data and rank the agents based on their average AHT. The person with the lowest AHT should be ranked 1. Column is highlighed in green for your reference. Based on this ranking the work sheet named "Ranking" should be updated automatically. Since I am taking a weighted average for all agents, the one who gets the lowest AHT should be ranked 1st . In the ranking work sheet the agent with ranking 1 should be given 100, the second highest ranked person should get 98,third 96,fourth 94 etc. Can anyone help?

Regards

Rakesh

Hi

AHT Summary
Cell A3 =RANK(E3,$E$3:$E$9)+COUNTIF($E$3:E3,E3)-1 for High Rank.
If you want low Rank put in =RANK(E3,$E$3:$E$9,1)+COUNTIF($E$3:E3,E3)-1

Ranking
Cell A2 =RANK(G2,$G$2:$G$8)+COUNTIF($G$2:G2,G2)-1 High Rank.
Lower =RANK(G2,$G$2:$G$8,1)+COUNTIF($G$2:G2,G2)-1.

Then Vlookup.

click on the attachment.