Win and loss streak

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