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
Bookmarks