Jun 30 2018 02:48 PM
Jul 01 2018 11:35 AM
Yes this is definitely possible. A friend of mine used to run a weekly NFL Pool for bragging rights and he came up with this spreadsheet. It's nothing fancy but it seemed to get the job done. It's pretty basic.... it looks at the match ups for each week and if the team in Row 5 matches the team for the individual it will give them points (Column T) . It sounds like what you want to do is the opposite. If you look at this spreadsheet you can get your bearings and simply adjust it.
Please see attached for reference....
Jul 21 2020 10:03 AM
@Mike Schlodder Hi Mike, did you ever get this to work? If so, I'd be interested to know how! Thanks!
Jul 21 2020 11:03 AM
Jul 20 2021 10:57 AM
@Mike Schlodder Any luck with this? I'm looking for the same thing for this coming season and I'm drawing a blank... thank you :)