Wins + Losses for Sports Teams at Different Points

alex58392

New Member
Joined
Jun 2, 2019
Messages
2
Hi all,
First time posting and looking for some help regarding a set of sports statistics. I am looking to analyze the effect of home court advantage in the 2018-2019 season and wanted to be able to control for how many wins each team has at a certain time in the season. I currently have a set of 1230 games. Each row has the score of the game for the away team and the home team along with neighboring columns stating the identity of the home team and the away team. I was wondering if it is possible to create a formula that can analyze the scores of each game and which team they correspond to so as to calculate a sort of "running wins and losses total" that borders each game played. For example, if the Golden State Warriors have played 6 games and won 5 of them, I would like the row indicating their seventh game to have 5 wins next to it so I can attempt to control for individual team performance (a better team wins more games) in regressing for home court advantage. Thank you in advance for any help, please let me know if you have any questions. Thanks!
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
please you post a small sample and desired output of the data here
 
Upvote 0
[TABLE="width: 1365"]
<colgroup><col width="65" span="21" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="width: 65"][/TD]
[TD="width: 65"]ROAD TEAM[/TD]
[TD="width: 65"]HOME TEAM[/TD]
[TD="width: 65"]Away Points Scored[/TD]
[TD="width: 65"]Home Points Scored[/TD]
[TD="width: 65"]Difference[/TD]
[TD="width: 65"]Away Days Rest[/TD]
[TD="width: 65"]Home Days Rest[/TD]
[TD="width: 65"]Attend.[/TD]
[TD="width: 65"]Away 3IN4-B2B[/TD]
[TD="width: 65"]Away B2B[/TD]
[TD="width: 65"]Away 3IN4[/TD]
[TD="width: 65"]Away 1[/TD]
[TD="width: 65"]Away 2[/TD]
[TD="width: 65"]Away 3More[/TD]
[TD="width: 65"]Home 3IN4-B2B[/TD]
[TD="width: 65"]Home B2B[/TD]
[TD="width: 65"]Home 3IN4[/TD]
[TD="width: 65"]Home 1[/TD]
[TD="width: 65"]Home 2[/TD]
[TD="width: 65"]Home 3More[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/16/18[/TD]
[TD]Philadelphia 76ers[/TD]
[TD]Boston Celtics[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]18[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]18624[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/16/18[/TD]
[TD]Oklahoma City Thunder[/TD]
[TD]Golden State Warriors[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]108[/TD]
[TD="align: right"]8[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]19596[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]Milwaukee Bucks[/TD]
[TD]Charlotte Hornets[/TD]
[TD="align: right"]113[/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]-1[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]17889[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]Brooklyn Nets[/TD]
[TD]Detroit Pistons[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]103[/TD]
[TD="align: right"]3[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]20332[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]New Orleans Pelicans[/TD]
[TD]Houston Rockets[/TD]
[TD="align: right"]131[/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]-19[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]18055[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]Memphis Grizzlies[/TD]
[TD]Indiana Pacers[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]111[/TD]
[TD="align: right"]28[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]17923[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]Denver Nuggets[/TD]
[TD]Los Angeles Clippers[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]98[/TD]
[TD="align: right"]-9[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]19068[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]Atlanta Hawks[/TD]
[TD]New York Knicks[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]126[/TD]
[TD="align: right"]19[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]18249[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]Miami Heat[/TD]
[TD]Orlando Magic[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"]3[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]19191[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]Dallas Mavericks[/TD]
[TD]Phoenix Suns[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]121[/TD]
[TD="align: right"]21[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]18055[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]Utah Jazz[/TD]
[TD]Sacramento Kings[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]117[/TD]
[TD="align: right"]-6[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]17583[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]Minnesota Timberwolves[/TD]
[TD]San Antonio Spurs[/TD]
[TD="align: right"]108[/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]4[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]18354[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]Cleveland Cavaliers[/TD]
[TD]Toronto Raptors[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"]116[/TD]
[TD="align: right"]12[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]19915[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/18/18[/TD]
[TD]Chicago Bulls[/TD]
[TD]Philadelphia 76ers[/TD]
[TD="align: right"]108[/TD]
[TD="align: right"]127[/TD]
[TD="align: right"]19[/TD]
[TD]3More[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]20302[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/18/18[/TD]
[TD]Los Angeles Lakers[/TD]
[TD]Portland Trail Blazers[/TD]
[TD="align: right"]119[/TD]
[TD="align: right"]128[/TD]
[TD="align: right"]9[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]19996[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/18/18[/TD]
[TD]Miami Heat[/TD]
[TD]Washington Wizards[/TD]
[TD="align: right"]113[/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]-1[/TD]
[TD]B2B[/TD]
[TD]3More[/TD]
[TD="align: right"]20409[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/19/18[/TD]
[TD]New York Knicks[/TD]
[TD]Brooklyn Nets[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]17732[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/19/18[/TD]
[TD]Oklahoma City Thunder[/TD]
[TD]Los Angeles Clippers[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]108[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]14816[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/19/18[/TD]
[TD]Atlanta Hawks[/TD]
[TD]Memphis Grizzlies[/TD]
[TD="align: right"]117[/TD]
[TD="align: right"]131[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]17019[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/19/18[/TD]
[TD]Indiana Pacers[/TD]
[TD]Milwaukee Bucks[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]118[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]17341[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/19/18[/TD]
[TD]Cleveland Cavaliers[/TD]
[TD]Minnesota Timberwolves[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]131[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]18978[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/19/18[/TD]
[TD]Sacramento Kings[/TD]
[TD]New Orleans Pelicans[/TD]
[TD="align: right"]129[/TD]
[TD="align: right"]149[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]18337[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/19/18[/TD]
[TD]Charlotte Hornets[/TD]
[TD]Orlando Magic[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]-32[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]17668[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/19/18[/TD]
[TD]Boston Celtics[/TD]
[TD]Toronto Raptors[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]113[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]19800[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/19/18[/TD]
[TD]Golden State Warriors[/TD]
[TD]Utah Jazz[/TD]
[TD="align: right"]124[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]-1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]18306[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/20/18[/TD]
[TD]Detroit Pistons[/TD]
[TD]Chicago Bulls[/TD]
[TD="align: right"]118[/TD]
[TD="align: right"]116[/TD]
[TD="align: right"]-2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]21289[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/20/18[/TD]
[TD]Minnesota Timberwolves[/TD]
[TD]Dallas Mavericks[/TD]
[TD="align: right"]136[/TD]
[TD="align: right"]140[/TD]
[TD="align: right"]4[/TD]
[TD]3IN4-B2B[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]20205[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/20/18[/TD]
[TD]Phoenix Suns[/TD]
[TD]Denver Nuggets[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]119[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]19592[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/20/18[/TD]
[TD]Brooklyn Nets[/TD]
[TD]Indiana Pacers[/TD]
[TD="align: right"]103[/TD]
[TD="align: right"]132[/TD]
[TD="align: right"]29[/TD]
[TD]3IN4-B2B[/TD]
[TD]3IN4-B2B[/TD]
[TD="align: right"]17007[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/20/18[/TD]
[TD]Houston Rockets[/TD]
[TD]Los Angeles Lakers[/TD]
[TD="align: right"]124[/TD]
[TD="align: right"]115[/TD]
[TD="align: right"]-9[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]18997[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/20/18[/TD]
[TD]Charlotte Hornets[/TD]
[TD]Miami Heat[/TD]
[TD="align: right"]113[/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]-1[/TD]
[TD]3IN4-B2B[/TD]
[TD]3IN4[/TD]
[TD="align: right"]19600[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/20/18[/TD]
[TD]Boston Celtics[/TD]
[TD]New York Knicks[/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]-11[/TD]
[TD]B2B[/TD]
[TD]3IN4-B2B[/TD]
[TD="align: right"]19427[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/20/18[/TD]
[TD]Orlando Magic[/TD]
[TD]Philadelphia 76ers[/TD]
[TD="align: right"]115[/TD]
[TD="align: right"]116[/TD]
[TD="align: right"]1[/TD]
[TD]3IN4-B2B[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]20300[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/20/18[/TD]
[TD]San Antonio Spurs[/TD]
[TD]Portland Trail Blazers[/TD]
[TD="align: right"]108[/TD]
[TD="align: right"]121[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]19461[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/20/18[/TD]
[TD]Toronto Raptors[/TD]
[TD]Washington Wizards[/TD]
[TD="align: right"]117[/TD]
[TD="align: right"]113[/TD]
[TD="align: right"]-4[/TD]
[TD]3IN4-B2B[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]16185[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/21/18[/TD]
[TD]Atlanta Hawks[/TD]
[TD]Cleveland Cavaliers[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]111[/TD]
[TD="align: right"]-22[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]19432[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/21/18[/TD]
[TD]Golden State Warriors[/TD]
[TD]Denver Nuggets[/TD]
[TD="align: right"]98[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]B2B[/TD]
[TD="align: right"]19520[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/21/18[/TD]
[TD]Houston Rockets[/TD]
[TD]Los Angeles Clippers[/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]115[/TD]
[TD="align: right"]3[/TD]
[TD]B2B[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]16149[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/21/18[/TD]
[TD]Sacramento Kings[/TD]
[TD]Oklahoma City Thunder[/TD]
[TD="align: right"]131[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]-11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]18203[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]

Here is a subset of the data, I would like to create two new columns, one containing the number of cumulative wins for the specific home team playing and another for the away team. If it is easier, I can reorient the data so that it is in alphabetical order by data (to group the same home and away teams together). Please let me know if this is better.
 
Upvote 0
have a look if this is what you're after


Book1
ABCDEFVW
1ROAD TEAMHOME TEAMAway Points ScoredHome Points ScoredDifferenceAway Days RestHOME winsAWAY wins
210/16/18Philadelphia 76ersBoston Celtics871051801
310/16/18Oklahoma City ThunderGolden State Warriors100108801
410/17/18Milwaukee BucksCharlotte Hornets113112-110
510/17/18Brooklyn NetsDetroit Pistons100103301
610/17/18New Orleans PelicansHouston Rockets131112-1910
710/17/18Memphis GrizzliesIndiana Pacers831112801
810/17/18Denver NuggetsLos Angeles Clippers10798-910
910/17/18Atlanta HawksNew York Knicks1071261901
1010/17/18Miami HeatOrlando Magic101104301
1110/17/18Dallas MavericksPhoenix Suns1001212101
1210/17/18Utah JazzSacramento Kings123117-610
1310/17/18Minnesota TimberwolvesSan Antonio Spurs108112401
1410/17/18Cleveland CavaliersToronto Raptors1041161201
1510/18/18Chicago BullsPhiladelphia 76ers1081271901
1610/18/18Los Angeles LakersPortland Trail Blazers119128901
1710/18/18Miami HeatWashington Wizards113112-110
1810/19/18New York KnicksBrooklyn Nets105107201
1910/19/18Oklahoma City ThunderLos Angeles Clippers921081601
2010/19/18Atlanta HawksMemphis Grizzlies1171311401
2110/19/18Indiana PacersMilwaukee Bucks1011181701
2210/19/18Cleveland CavaliersMinnesota Timberwolves123131801
2310/19/18Sacramento KingsNew Orleans Pelicans1291492001
2410/19/18Charlotte HornetsOrlando Magic12088-3211
2510/19/18Boston CelticsToronto Raptors1011131202
2610/19/18Golden State WarriorsUtah Jazz124123-110
2710/20/18Detroit PistonsChicago Bulls118116-210
2810/20/18Minnesota TimberwolvesDallas Mavericks136140401
2910/20/18Phoenix SunsDenver Nuggets911192801
3010/20/18Brooklyn NetsIndiana Pacers1031322902
3110/20/18Houston RocketsLos Angeles Lakers124115-910
3210/20/18Charlotte HornetsMiami Heat113112-120
3310/20/18Boston CelticsNew York Knicks112101-1111
3410/20/18Orlando MagicPhiladelphia 76ers115116102
3510/20/18San Antonio SpursPortland Trail Blazers1081211302
3610/20/18Toronto RaptorsWashington Wizards117113-410
3710/21/18Atlanta HawksCleveland Cavaliers133111-2210
3810/21/18Golden State WarriorsDenver Nuggets98100212
3910/21/18Houston RocketsLos Angeles Clippers112115312
4010/21/18Sacramento KingsOklahoma City Thunder131120-1110
Sheet2
Cell Formulas
RangeFormula
V2=SUMPRODUCT(--($B$2:B2=B2),--($F$2:F2<0))
W2=SUMPRODUCT(--($C$2:C2=C2),--($F$2:F2>0))
 
Upvote 0

Forum statistics

Threads
1,224,735
Messages
6,180,635
Members
452,991
Latest member
JM_000888

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top