What I'm asking is somewhat similar to what was discussed here: http://www.excelforum.com/excel-gene...ss-streak.html
I have a work book which tracks stats for a hockey team I work for. Each player has their own page with game logs, tracking goals, goal types, penalties and other hockey stats. I'm looking to calculate goal and point streaks off this.
I've included an example of what I'm looking for.
streak example.xlsx
I want to clarify that I'm not looking for the longest streak. Using the above example, if it's October 13th and this player gets 1 assist, then the goal streak goes to 0, the assist streak goes to 2 and the point streak goes to 6.
Bookmarks