Hello all, hope you can help as you have so well before. I have downloaded the NFL season by week onto a spreadsheet and am doing a survivor pool. I was trying (unsuccessfully) to generate the records for each team. My data is in columns A through AP up to line 17. I have tried both a countif by color as I was thinking of color filing the cell with a win as well as tried adding a W/L column next to all the team names and counting if one cell equals a team name and the following equals W. I can't quite get it to work across the board. Was hoping for a suggestion of an easier way or if someone can help with a formula. Below is the basic setup with each week being 5 columns, notice only the very first game has any data filled in the W/L columns. Any help is much appreciated and yes, I know I can just look at the NFL stats page, but will be doing my weekly picks from my sheet and would like it all in one place. If you need any further information/elaboration, feel free to ask.
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
| Week 1 | Week 2 | Week 3 | ||||||||||
| PANTHERS | W | AT | BRONCOS | L | JETS | AT | BILLS | TEXANS | AT | PATRIOTS | ||
| BUCCANEERS | AT | FALCONS | 49ERS | AT | PANTHERS | CARDINALS | AT | BILLS | ||||
| VIKINGS | AT | TITANS | COWBOYS | AT | REDSKINS | RAIDERS | AT | TITANS | ||||
| BROWNS | AT | EAGLES | BENGALS | AT | STEELERS | REDSKINS | AT | GIANTS | ||||
| BENGALS | AT | JETS | SAINTS | AT | GIANTS | BROWNS | AT | DOLPHINS | ||||
| RAIDERS | AT | SAINTS | DOLPHINS | AT | PATRIOTS | RAVENS | AT | JAGUARS | ||||
| CHARGERS | AT | CHIEFS | CHIEFS | AT | TEXANS | LIONS | AT | PACKERS | ||||
| BILLS | AT | RAVENS | TITANS | AT | LIONS | BRONCOS | AT | BENGALS | ||||
| BEARS | AT | TEXANS | RAVENS | AT | BROWNS | VIKINGS | AT | PANTHERS | ||||
| PACKERS | AT | JAGUARS | SEAHAWKS | AT | RAMS | RAMS | AT | BUCCANEERS | ||||
| DOLPHINS | AT | SEAHAWKS | BUCCANEERS | AT | CARDINALS | 49ERS | AT | SEAHAWKS | ||||
| GIANTS | AT | COWBOYS | JAGUARS | AT | CHARGERS | JETS | AT | CHIEFS | ||||
| LIONS | AT | COLTS | FALCONS | AT | RAIDERS | CHARGERS | AT | COLTS | ||||
| PATRIOTS | AT | CARDINALS | COLTS | AT | BRONCOS | STEELERS | AT | EAGLES | ||||
| STEELERS | AT | REDSKINS | PACKERS | AT | VIKINGS | BEARS | AT | COWBOYS | ||||
| RAMS | AT | 49ERS | EAGLES | AT | BEARS | FALCONS | AT | SAINTS |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
