selecting best player

[suparno]

In a tournament, I have 5 teams with 7 players. In one page, I have entered all player names with their Bowling (Overs, Mdns, Runs, Wickets, E/R) and Batting (Runs, Balls, Strike Rate).

I want ranked Best Batsman name automatically Appears in a separate Sheet considering the batsman data. Similarly, ranked Best Bowler and Best allrouder names appear considering bowler data and bowler & batsman both data.

Pls help

Suparno

 

[suparno]

In a tournament, I have 5 teams with 7 players. In one page, I have entered all player names with their Bowling (Overs, Mdns, Runs, Wickets, E/R) and Batting (Runs, Balls, Strike Rate).

Player Overs Mdns Runs RANK Wickets E/R Runs Balls S/R RANK
A
B
C
...

Though the tournament has not started yet, I want ranked Best Batsman name automatically Appears in a separate Sheet considering the batsman data. Similarly, ranked Best Bowler and Best allrouder names appear considering bowler data and bowler & batsman both data.

Pls help

Suparno