Cricket Spreadsheet - Show Best Values

I've been making a cricketing spreadsheet that is giving me a few problems.

1. I'm looking to find a way to show a person's highest score in the Stats sheet (column I).
2. I want to find a way to produce the top 10 bowling performances on the Top 10 Sheet. My attempts so far have been a little disastrous!
3. I want to change the top 10 batting performances in the Top 10 sheet, so that if there are two or more people who made the same score, each of their names is produced (rather than one name being shown, as is currently the case. It is telling me that B. Ramsay scored 63 three times, when in fact it is three different people who have scored 63!)
4. I want the best performances table to show the date of the performance.

Any help would be much appreciated. Thanks

Here's the spreadsheet

Hi,

This is a huge task for a novice like me... However after searching the forum this is for the highest score for each player. In I2 in Stats page put this formula. As this is an array formula, please press, CTRL+SHIFT+ENTER and then copy down

Please Login or Register  to view this content.

Will try to work on rest of it later...

Thanks, that solved the first problem perfectly! Much appreciated!