Win and loss streak

Hi wongum and welcome to the forum,

You are making it very hard to track your stats, based on your results page. I'd suggest changing the way you keep these results. I'd have these columns:
Game#, Team, W/L, PF, PA

Then when you enter your data you would have two rows for each game, like:
1, Legends, W, 96, 95
1, A & T, L, 95, 96
1, Pistols, W, 98, 75
1, C-Ment, L, 75, 98

If you keep your data like the above your standing sheet would be much easier to produce. Also, you could produce a better results sheet using Pivot Tables or AutoFilters.

Hi Wongum

For Win/Lost Streak.
Result sheet.
D75 =IF(MAX(D12:D74)=0,"",MAX(D12:D74)).
Next F75 =IF(MAX(F12:F74)=0,"",MAX(F12:F74)).
Next put AC8 Type> Legends. Then type Win in AC10 and Lost in AE10

This for Win Streak
Next AD12 =IF(B12="","",IF(D12=D$75,1,"-")) Then copy down to AD74.
Next AC12 =IF(AD12=1,D12&"-"&F12&" "&B12&""&"","") Then copy down to AC74

This for Lost Streak
Next AF12=IF(B12="","",IF(F12=F$75,1,"-")) Then copy down to AF74.
Next AE12 =IF(AF12=1,D12&"-"&F12&" "&B12&""&"","") Then copy down to AE74

If that what you looking for. Do the rest of the teams.

Cheer