Hi all, I have a data set attached which represents in minutes the times of goal scored in soccer matches.
In columns A to L I have the the home teams goals
In columns M to X I have the away teams goals
What I want to do in Y onwards is document the sequence of scoring as shown in the examples on line 2 and 3
Please can someone assist with the formula for doing this
Bookmarks