I have a sheet called fixtures and it is filtered into seasons, each entry represents one match and has players listed that played in a match. I want to be able to count how many times a player appeared in a each season. Any ideas? The seasons are cu...
I have 11 columns of linked records (a football team lineup), with a player in each slot of each column. Is it possible to calculate how many times the same name appears in all the columns in total in the separate linked players sheet?
Thanks, the more I look at it a single select isn’t vital. The being able to group and filter is more important. I hate to be ignorant but could you explain how I use the DATETIME_FORMAT() formula?
I currently have a date for each entry, next to the entry I would like an automatic “Month/Year”
So… 26/07/2018 and in the next cell automatically… “July 2018” so I can easily group entries together by their month.
Thanks @Andre_Zijlstra, that looks like the route I should be pursuing. One difference is I have 11 fields for the different starters rather than linking them all in the same field. I’m sure there’s a work around for this. Thanks again for your help.
@Andre_Zijlstra thanks, that’s very similar to what I have. The main difference is I have 13 seasons of fixtures with each season identified by a single select field. I’m looking to count players appearances by season, any ideas?
