C D E
94 1960 Boston L
95 1960 Dallas W
96 1961 Dallas L
97 1961 Boston L
98 1962 Dallas W
99 1962 Boston W
100 1963 Boston T
101 1963 Kansas City W
102 1964 Boston L
103 1964 Kansas City L
104 1965 Kansas City W
105 1965 Boston T
106 1966 Boston W
107 1966 Kansas City T
108 1967 Boston W
109 1968 Kansas City W
110 1969 Chestnut HillW
111 1970 Kansas City W

Longest Winning Streak 4 =MAX(FREQUENCY(IF(E94:E112="W",ROW(E94:E112)),IF(E94:E112<>"W",ROW(E94:E112))))
Longest Losing Streak 2 =MAX(FREQUENCY(IF(E94:E112="L",ROW(E94:E112)),IF(E94:E112<>"L",ROW(E94:E112))))

As you can see I have found a way to use colume E and find longest winning streak and longest losing streaks

Now I am wanting to combine Colume E with Colume D and track the longest win/loss streak at the location

For example I am wanting to show:

Longest Winning Streak at Kansas City 3
Longest Winning Streak at Boston 2
Longest Winning Streak at Dallas 1

and also the same thing for Longest Losing Streak

Can anyone help me out. I am very stumped.