Longest winning sequence in a sports league - out of all teams

[torrenchula]

Hi all,

I have an excel sheet of all result a football (soccer) league of the past 25 years and am searching for a way to find out the longest winning run (also longest losing, unbeaten and winless runs) of ALL teams in the league, not just for a single team.

This is the basic format of the table, (each result is duplicated twice to produced home and away and the result from the perspective of each team).

[TABLE="width: 551"]
<colgroup><col span="2"><col><col><col><col></colgroup><tbody>[TR]
[TD]Cerezo Osaka[/TD]
[TD]Yokohama F. Marinos[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]H[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Yokohama F. Marinos[/TD]
[TD]Cerezo Osaka[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]A[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]JEF United Ichihara Chiba[/TD]
[TD]Kashiwa Reysol[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]H[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Kashiwa Reysol[/TD]
[TD]JEF United Ichihara Chiba[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]A[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Kashima Antlers[/TD]
[TD]Gamba Osaka[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]H[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Gamba Osaka[/TD]
[TD]Kashima Antlers[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]A[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Kawasaki Frontale[/TD]
[TD]Urawa Reds[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]H[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Urawa Reds[/TD]
[TD]Kawasaki Frontale[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]A[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Omiya Ardija[/TD]
[TD]Vissel Kobe[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]H[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Vissel Kobe[/TD]
[TD]Omiya Ardija[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]A[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Sanfrecce Hiroshima[/TD]
[TD]FC Tokyo[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]H[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]FC Tokyo[/TD]
[TD]Sanfrecce Hiroshima[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]A[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Tokyo Verdy [/TD]
[TD]Shimizu S-Pulse[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]H[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Shimizu S-Pulse[/TD]
[TD]Tokyo Verdy [/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]A[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Albirex Niigata[/TD]
[TD]Oita Trinita[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]H[/TD]
[TD]W[/TD]
[/TR]
[TR]
[TD]Oita Trinita[/TD]
[TD]Albirex Niigata[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]A[/TD]
[TD]W[/TD]
[/TR]
[TR]
[TD]Jubilo Iwata[/TD]
[TD]Nagoya Grampus[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]H[/TD]
[TD]L[/TD]
[/TR]
[TR]
[TD]Nagoya Grampus[/TD]
[TD]Jubilo Iwata[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]A[/TD]
[TD]L[/TD]
[/TR]
[TR]
[TD]FC Tokyo[/TD]
[TD]Shimizu S-Pulse[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]H[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Shimizu S-Pulse[/TD]
[TD]FC Tokyo[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]A[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Kashiwa Reysol[/TD]
[TD]Kashima Antlers[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]H[/TD]
[TD]L[/TD]
[/TR]
[TR]
[TD]Kashima Antlers[/TD]
[TD]Kashiwa Reysol[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]A[/TD]
[TD]W[/TD]
[/TR]
[TR]
[TD]Nagoya Grampus[/TD]
[TD]Sanfrecce Hiroshima[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]H[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Sanfrecce Hiroshima[/TD]
[TD]Nagoya Grampus[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]A[/TD]
[TD]D[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 551"]
<colgroup><col span="2"><col><col><col><col></colgroup><tbody>[TR]
[TD]Kashiwa Reysol[/TD]
[TD]Kashima Antlers[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]H[/TD]
[TD]L[/TD]
[/TR]
[TR]
[TD]Kashima Antlers[/TD]
[TD]Kashiwa Reysol[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]A[/TD]
[TD]W[/TD]
[/TR]
[TR]
[TD]Nagoya Grampus[/TD]
[TD]Sanfrecce Hiroshima[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]H[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Sanfrecce Hiroshima[/TD]
[TD]Nagoya Grampus[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]A[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Oita Trinita[/TD]
[TD]Urawa Reds[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]H[/TD]
[TD]W[/TD]
[/TR]
[TR]
[TD]Urawa Reds[/TD]
[TD]Oita Trinita[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]A[/TD]
[TD]L[/TD]
[/TR]
</tbody>[/TABLE]

i.e. from the results above - both Kashima Antlers and Oita Trinita would have the longest winnign runs at 2 each. What would be the formula to use to find the longest winning run?

Many thanks in advance

 

[torrenchula]

Bad example perhaps as I noticed I inputted one result incorrectly (Oita v Albirex). Kashima have the longest winning run at 2 in this sequence still.