Counting the first and second best ranks for a ranking spreadsheet

[swik78]

Hi All,
I am struggling with getting this to work using Excel formulas. If anyone can help, would be highly appreciated!
I have a table that stores Matches between players and records the Winners/ Losers Name. It also shows the State Ranking of the Losing Player.
Now I need to create a list with the names of all players and show the number of wins and losses along with recording the Rank of the best player they beat.

Example: Match records

Player1	Player2	Winner	Loser	Winner Rank	Loser Rank
Tom	John	Tom	John	5	3
Lewis	Ron	Ron	Lewis	10	5
Ron	Dave	Ron	Dave	10	2
Lewis	James	James	Lewis	1	4
James	Tony	Tony	James	6	1
Tony	Ron	Ron	Tony	10	6

<tbody>
</tbody>

The list I am trying to create is as follows. Is there a way to create a BestWin Rank for each player? I am fine with counting the #Wins and #Losses.
I guess this needs to loop through all the Wins for that player and then in that subset return the rank of the best player beaten.

Sorry, If I havent explained this well! Any help/ pointers will be greatly appreciated! Thanks!

Player #Wins #Losses BestWin Rank Ron 3 ???2 i.e The best Rank of Players that Ron beat above i.e Smallest of (5,2,6 ) which is 2 John 1 ?? Dave 1 ? Tony 1 1 Lewis 2 James 1 1 Tom 1 <tbody> </tbody>

<tbody>
</tbody>