I was trying to understand how I would create a calculated field that will tell me how many shots a player has taken since their last goal.
In 'sheet1' I want to count 'outcome' since 'outcome' was 'goal' - I don't have a clue where to start or how to express this using a calculated field, or even if it can be done, though I have seen similar things done with time since an event occurred.
I'm hoping this makes sense, and someone has an easy to understand answer?
I have attached my workbook. Any advice is welcome