Hi All
I'm trying to find ways of getting relevant statistics for my local pub darts team.
Below is a picture of one 'tab' from the spreadsheet.
I have a separate tab for each game we play in the season.
As you can probably guess, a lot of the content is already automated.
e.g. the score in yellow, the amount of games played, the red/green win/lose functions etc....
What I'm after is some of the functions on a 'General' tab
On the first tab of my workbook, I have a layout similar to below..
<tbody>
</tbody>
This, is what I need help on please.
I already use a Data/pull down list on each score sheet based on this first column.
For column-2 I'd like to know how many games night they turned up to. I can't do a simple count if, because their names might appear more than once in an evening.
Plus, the fact, I would struggle to spread the 'search' over all the tabs I create (more than a dozen darts evenings).
Another question: How could I list the highest 'out' score (double finish) that ... 'Brian' might score throughout the season, when his name may, or may not appear 'somewhere' on more than one tab.
If any of the moderators of this forum will allow me to post an actual spreadsheet, it may make it easier for you guys to have a 'play' with what I've created so far.
Thank you in advance
My timescale is: The season started 3 weeks ago
regards
Larry.
I'm trying to find ways of getting relevant statistics for my local pub darts team.
Below is a picture of one 'tab' from the spreadsheet.
I have a separate tab for each game we play in the season.
As you can probably guess, a lot of the content is already automated.
e.g. the score in yellow, the amount of games played, the red/green win/lose functions etc....
What I'm after is some of the functions on a 'General' tab
On the first tab of my workbook, I have a layout similar to below..
| Player | Games Attended | Singles Played | Doubles Played | Pub Supporter | Highest score/season | Best out /season | |
| Fred | |||||||
| John | |||||||
| Eric | |||||||
| Dave | |||||||
| Alan | |||||||
| Craig | |||||||
| Jeff | |||||||
| Brian | |||||||
| Derek |
<tbody>
</tbody>
This, is what I need help on please.
I already use a Data/pull down list on each score sheet based on this first column.
For column-2 I'd like to know how many games night they turned up to. I can't do a simple count if, because their names might appear more than once in an evening.
Plus, the fact, I would struggle to spread the 'search' over all the tabs I create (more than a dozen darts evenings).
Another question: How could I list the highest 'out' score (double finish) that ... 'Brian' might score throughout the season, when his name may, or may not appear 'somewhere' on more than one tab.
If any of the moderators of this forum will allow me to post an actual spreadsheet, it may make it easier for you guys to have a 'play' with what I've created so far.
Thank you in advance
My timescale is: The season started 3 weeks ago
regards
Larry.
Last edited:
