team1

<tbody> TABLE1 J A N U A R Y 1 2 3 4 5 6 7 8 9 10 TEAM1 X X X X X TEAM2 X X X X X TEAM3 X X </tbody> <tbody> TABLE2 TASK START DATE END DATE TEAM1 Y 1jan 3jan TEAM2 X 3jan 7jan TEAM3 B 9jan 10jan TEAM1 X 7jan 8jan </tbody> I am having issues with TABLE1...

I'm currently using =IF(B1=B2,C1,MAX($C$1:C1)+1) in column C and it works fine to establish a sequential numbering, but not sure how to adjust for a new year. Data Range <tbody> A B C 1 Year Team Series 2 2018 Team1 1 3 2018 Team1 1 4 2018 Team1 1 5 2018 Team2...

Hello. In columns A and B (A2:B400) I have a list of all games in one season, home team is in column A and away team in column B. Columns C and D shows game outcome Win or Loss (W/L). I need a formula (or VBA) to count the number of current win/loss streaks after each game and to place those...

So I have the following: <tbody> A B C D E F G H I J 5 1 Team1 ... ... ... ... ... ... 80 5 2 Team2 ... ... ... ... ... ... 95 5 3 Team3 ... ... ... ... ... ... 88 5 4 Team3 ... ... ... ... ... ... 82 5 5 Team2 ... ... ... ... ... ... 84 5 6 Team4 ... ... ... ... ... ... 92 5 7...

I've been trying to finding the solution to my problem, but figured I'd finally reach out to the professionals. The Table. Row 1 would be a list of games being played. B1 would be team1 vs team2, C1 would be team3 vs team 4, D1 team5 vs team6. Row 2 would have a list of the team that won...