Hello. I've been keeping track of all our goal scorers from a local 5-aside futsal league.
I want to make it more interesting by adding in 'goal streaks'. So if a player scores in week 1, week 2, week 3 and week 4 it will display in a column next to their name saying they have scored in 4 consecutive games. as soon as they fail to score in a game (record a 0) then the goal streak column should reset to 0. However some weeks a team will be on their week off so I want blank cells to be disregarded and not break the streak.
The league will be going on for around 15 weeks possibly longer so the data will need to continue indefinably if possible.
I've been looking around this forum and i haven't found anything that exactly suits my needs, a lot of formulas I've seen are in columns or only work with wins or losses etc.
Also help automating the 'position' coloumn would be great + a way to organise alaphbeticazlly when two players have scored the same amount would be great.
There is no fomulas being used at all currently, Ive been entering all the data manually and using the sort & filter > Largest to smallest function.
First time posting on the site, any help would be really appreciated
Cheers & Regards,
Lewis
Bookmarks