Problems with Excel formula? (semi-related to previous questions) Answered
i've got a problem with a formula in my excel spreadsheet that i'm using to get the scores for NFL teams 1978 - Current
i have the data ok but the problem is with matching the the specific games.
i've CONCATENATED the data to provide unique data points also it's in two columns (Home & Visitor) in the format of
YearTeamW/L/DScore eg. 2012TitansW35
in the VERY unlikely event (and i've check a random selection) that the team has 2 wins at home with the same score this could cause an error.
here is the formula i'm using: (version ~8000zzzzz lol) (all one formula, just added a line break to make it fit)
Here's a link to the folder with the spreadsheet. (NFL Stuf (test).xlsx)
Sheet: Past Season Summary - what is says. eventually where the formula is going.
Sheet: nfl2011lines - 92 - the data (actually 1978 - 2012 but i named it before i added all the data)
Sheet: TESTING - my "sandbox" so i don't [Censored] the main sheets