Hi all,
Looking for a formula to count most consecutive wins/losses vs a particular team. (Basically the longest winning or losing streak streak)

A2:A2000 contains "w" for win or "L" for loss B2:B2000 contains "team name" for example "Dragons"

I would like to output answer in c2.

I dont know if you need more information than that..if so please let me know.