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).

Cerezo Osaka	Yokohama F. Marinos	3	3	H	D
Yokohama F. Marinos	Cerezo Osaka	3	3	A	D
JEF United Ichihara Chiba	Kashiwa Reysol	2	2	H	D
Kashiwa Reysol	JEF United Ichihara Chiba	2	2	A	D
Kashima Antlers	Gamba Osaka	2	2	H	D
Gamba Osaka	Kashima Antlers	2	2	A	D
Kawasaki Frontale	Urawa Reds	3	3	H	D
Urawa Reds	Kawasaki Frontale	3	3	A	D
Omiya Ardija	Vissel Kobe	1	1	H	D
Vissel Kobe	Omiya Ardija	1	1	A	D
Sanfrecce Hiroshima	FC Tokyo	0	0	H	D
FC Tokyo	Sanfrecce Hiroshima	0	0	A	D
Tokyo Verdy	Shimizu S-Pulse	0	0	H	D
Shimizu S-Pulse	Tokyo Verdy	0	0	A	D
Albirex Niigata	Oita Trinita	2	1	H	W
Oita Trinita	Albirex Niigata	2	1	A	W
Jubilo Iwata	Nagoya Grampus	0	3	H	L
Nagoya Grampus	Jubilo Iwata	0	3	A	L
FC Tokyo	Shimizu S-Pulse	1	1	H	D
Shimizu S-Pulse	FC Tokyo	1	1	A	D
Kashiwa Reysol	Kashima Antlers	1	3	H	L
Kashima Antlers	Kashiwa Reysol	3	1	A	W
Nagoya Grampus	Sanfrecce Hiroshima	1	1	H	D
Sanfrecce Hiroshima	Nagoya Grampus	1	1	A	D

<colgroup><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>

Kashiwa Reysol	Kashima Antlers	1	3	H	L
Kashima Antlers	Kashiwa Reysol	3	1	A	W
Nagoya Grampus	Sanfrecce Hiroshima	1	1	H	D
Sanfrecce Hiroshima	Nagoya Grampus	1	1	A	D
Oita Trinita	Urawa Reds	1	0	H	W
Urawa Reds	Oita Trinita	0	1	A	L

<colgroup><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>

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.