Cricket Club Career Spreadsheet

[alburger]

Hi, I am building an Excel spreadsheet for my cricket club where I can enter season by season stats and the spreadsheet will rank each player by runs, games, wickets and catches. When complete if anyone wants to use this spreadsheet please feel free.
First problem, I need a formula that will give me the bowlers best season bowling figures in AB24 ( with stats from AB4 to AB23).(Player template tab)
I don't mind if the bowling figures are shown as 1/5 or 1-5. For any Americans or other nationalities that don't know about cricket,
1/5
4/65
4/32
Out of these numbers the last one would be the best career bowling figures. The highest first number ( wickets) and the lowest second number ( runs) give you the best figures.

Now secondly, (I wish to have a tab for each player, probably 100+, after I fix the first problem I can just copy the player template tab over and over). I would like to rank them on the Leading games, Leading runs, Leading wickets and Leading catches tab. (Leading games tab for example) So I would like to pull the stat (C24) and the players name (S1) into the Leading games tab and rank them from highest to lowest.

Leading runs stat (N24) players name (S1)

Leading wickets (V24) players name (S1)

Leading catches (P24) players name (S1)



Any help would be greatly appreciated.
Thanks in advance.

[zumbalj]

It will probably work better if you separate the data into separate cells rather that separate with a / or -. Then you can use the LARGE or SMALL function to determine his/her largest or smallest value for that particular item (whichever is important to you).

Then you'll need a sheet that lists all the players best & again use LARGE or SMALL functions to determine who's best is best. Make sure in this list you have the link to the players name in a cell to the right of the score so you can use VLOOKUP to pull the name. Then you can use CONCATENATE to join text and cell values to say who is the best at what.

100+ tabs will likely give you a VERY large file. If you can somehow consense, it will probably reduce your file size and help the sheet run faster.