Autonomous
New Member
- Joined
- Apr 30, 2019
- Messages
- 5
This is my first post on MrExcel and I really need a hand... I have a multi team game log where the dates are out of order and the data doesn't contain who played who so each team must be handled independently. I'm trying to figure out win streaks and current streaks "for each" team (Should I be writing VBA instead?) but my arrays aren't working properly. Any help would be appreciated!
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="width: 103"][/TD]
[TD="width: 103, align: center"]A[/TD]
[TD="width: 103, align: center"]B[/TD]
[TD="width: 135, align: center"]C[/TD]
[TD="width: 148, align: center"]D[/TD]
[TD="width: 147, align: center"]E
[/TD]
[/TR]
[TR]
[TD="width: 103"]1[/TD]
[TD="width: 103"]3 Teams [/TD]
[TD="width: 103"]Date[/TD]
[TD="width: 135"]Result[/TD]
[TD="width: 148"]Max Win Streak[/TD]
[TD="width: 147"]Current Streak[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Red[/TD]
[TD="align: right"]1/20/2019[/TD]
[TD]Win[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Red[/TD]
[TD="align: right"]1/21/2019[/TD]
[TD]Win[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Red[/TD]
[TD="align: right"]4/20/2019[/TD]
[TD]Loss[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Blue[/TD]
[TD="align: right"]1/10/2019[/TD]
[TD]Loss[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Blue[/TD]
[TD="align: right"]1/2/2019[/TD]
[TD]Win[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Blue[/TD]
[TD="align: right"]1/4/2019[/TD]
[TD]Win[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Blue[/TD]
[TD="align: right"]1/9/2019[/TD]
[TD]Win[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Red[/TD]
[TD="align: right"]3/20/2019[/TD]
[TD]Win[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]Red[/TD]
[TD="align: right"]1/6/2019[/TD]
[TD]Win[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]Red[/TD]
[TD="align: right"]1/7/2019[/TD]
[TD]Win[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]Green[/TD]
[TD="align: right"]1/15/2019[/TD]
[TD]Loss[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]Red[/TD]
[TD="align: right"]1/22/2019[/TD]
[TD]Win[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]Green[/TD]
[TD="align: right"]2/13/2019[/TD]
[TD]Win[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Blue[/TD]
[TD="align: right"]1/3/2019[/TD]
[TD]Loss[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]Green[/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]Loss[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="width: 103"][/TD]
[TD="width: 103, align: center"]A[/TD]
[TD="width: 103, align: center"]B[/TD]
[TD="width: 135, align: center"]C[/TD]
[TD="width: 148, align: center"]D[/TD]
[TD="width: 147, align: center"]E
[/TD]
[/TR]
[TR]
[TD="width: 103"]1[/TD]
[TD="width: 103"]3 Teams [/TD]
[TD="width: 103"]Date[/TD]
[TD="width: 135"]Result[/TD]
[TD="width: 148"]Max Win Streak[/TD]
[TD="width: 147"]Current Streak[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Red[/TD]
[TD="align: right"]1/20/2019[/TD]
[TD]Win[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Red[/TD]
[TD="align: right"]1/21/2019[/TD]
[TD]Win[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Red[/TD]
[TD="align: right"]4/20/2019[/TD]
[TD]Loss[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Blue[/TD]
[TD="align: right"]1/10/2019[/TD]
[TD]Loss[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Blue[/TD]
[TD="align: right"]1/2/2019[/TD]
[TD]Win[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Blue[/TD]
[TD="align: right"]1/4/2019[/TD]
[TD]Win[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Blue[/TD]
[TD="align: right"]1/9/2019[/TD]
[TD]Win[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Red[/TD]
[TD="align: right"]3/20/2019[/TD]
[TD]Win[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]Red[/TD]
[TD="align: right"]1/6/2019[/TD]
[TD]Win[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]Red[/TD]
[TD="align: right"]1/7/2019[/TD]
[TD]Win[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]Green[/TD]
[TD="align: right"]1/15/2019[/TD]
[TD]Loss[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]Red[/TD]
[TD="align: right"]1/22/2019[/TD]
[TD]Win[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]Green[/TD]
[TD="align: right"]2/13/2019[/TD]
[TD]Win[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Blue[/TD]
[TD="align: right"]1/3/2019[/TD]
[TD]Loss[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]Green[/TD]
[TD="align: right"]1/14/2019[/TD]
[TD]Loss[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]