Combining Win/Loss Streak with location

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.

it easy if you using SumProduct

please see attached file

Thank you. except the formula you provided is returning incorrect numbers. It is returning:

Longest Winning Streak at Kansas City 4
Boston 3
Dallas 2

and It should be:

Longest Winning Streak at Kansas City 2
Boston 2
Dallas 1

since my team won in Dallas, Lost in Dallas, then won in Dallas then the Longest winning streak in Dallas should be 1.

Thank you. except the formula you provided is returning incorrect numbers. It is returning:

Longest Winning Streak at Kansas City 4
Boston 3
Dallas 2

and It should be:

Longest Winning Streak at Kansas City 2
Boston 2
Dallas 1

since my team won in Dallas, Lost in Dallas, then won in Dallas then the Longest winning streak in Dallas should be 1.

I don't know how you guys do it but it works. thank you very very much

Thank you so very much. I have just one more thing to ask. Please see my attached spreadsheet.

Please note the red question marks.

I am wanting to combine the location column with the W/L column and show the current Winning Streak based on location.

Example:
Current Winning Streak at Kansas City should be 1 (Cell E16)
Current Losing Streak at Kansas City should be 0 (Cell F16)
Current Winning Streak at St. Louis should be 0 (Cell E17)
Current Losing Streak at St. Louis should be 1 (Cell F17)

Example.xlsx

Can anyone help me out with this one? It is certintally beyond me.

Worked like a champ. Thank you very much. Thanks to you my love for sports statistics can flourish.