This may sound complicated so bear with me!
I am looking for a formula that counts the number of times a trend occurs in a row.
Here is an example
Home Away Result Trend England 2 3 Germany LOSS 2 Netherlands 2 1 England LOSS 2 Spain 2 2 England DRAW 1 England 2 0 Russia WIN 2 England 3 1 Belgium WIN 2 Italy 4 2 England LOSS 1
In the trend column is where I want the formula to be. So if a team goes on run of 2 Losses, then 2 would be beside both matches, the same Wins and Draws.
Thanks
Bookmarks