I have read numerous posts on how this is achieved, but I cannot apply my data to any of the solutions to get my results. I have a number of results Win, Loss or Draw from our local football League. I am trying to count the most wins in succession by any one team.
The table is designed as the following example:
R Team Res Year
1 Bulls W 1999
2 Bulls W 1999
3 Bulls W 1999
4 Bulls W 1999
5 Bulls L 1999
6 Bulls D 1999
7 Bulls W 1999
8 Bulls W 1999
So the most wins in succession would be '4' (from R 1 to R4). This is just for one Team where as I have many Teams to work out the information I need. Thank-you in advance for any assistance you may be able to give me.
The table is designed as the following example:
R Team Res Year
1 Bulls W 1999
2 Bulls W 1999
3 Bulls W 1999
4 Bulls W 1999
5 Bulls L 1999
6 Bulls D 1999
7 Bulls W 1999
8 Bulls W 1999
So the most wins in succession would be '4' (from R 1 to R4). This is just for one Team where as I have many Teams to work out the information I need. Thank-you in advance for any assistance you may be able to give me.
