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!
<tbody>
</tbody>
A | B | C | D | E | |
1 | 3 Teams | Date | Result | Max Win Streak | Current Streak |
2 | Red | 1/20/2019 | Win | ||
3 | Red | 1/21/2019 | Win | ||
4 | Red | 4/20/2019 | Loss | ||
5 | Blue | 1/10/2019 | Loss | ||
6 | Blue | 1/2/2019 | Win | ||
7 | Blue | 1/4/2019 | Win | ||
8 | Blue | 1/9/2019 | Win | ||
9 | Red | 3/20/2019 | Win | ||
10 | Red | 1/6/2019 | Win | ||
11 | Red | 1/7/2019 | Win | ||
12 | Green | 1/15/2019 | Loss | ||
13 | Red | 1/22/2019 | Win | ||
14 | Green | 2/13/2019 | Win | ||
15 | Blue | 1/3/2019 | Loss | ||
16 | Green | 1/14/2019 | Loss |
<tbody>
</tbody>