Hello, In the attached data file I am trying to return each teams most recent margin of victory from their last game and put them in columns G and H. So for cell g2, I would like the value of F31 returned as this is the last game that denver played. For cell h2, I would like the value of f26 returned as this is the away team's last game. It doesn't matter if the last game is home or away, it just needs to be the most recent game. Any help would be greatly appreciated! Thank you!
Bookmarks