Quote:
Originally Posted by Travis Hoffman
VLOOKUPS require sorted fields for searching. Sort the OPR data by team number, not by OPR.
|
I didn't make the spreadsheet, just the observation that it was wrong. I think somebody in the other thread said they are going to fix it later today.
On another note, I see that some teams have 9 matches while others have 8. I'm guessing that the T or F next to the team number on the version FIRST released indicates whether or not it's a surrogate match.