I've created a spreadsheet to keep track of our online league, but I've ran into trouble trying to create a formula or helper columns to count records vs. division opponents and conference opponents. I also have ran into trouble calculating current winning/losing streak and last 5 game results. I've tried multiple attempts at using helper columns and counting 1 and -1 for wins or losses. I've attached my current worksheet, if anyone could point me in the right direction.
I feel like I'm close, but for example counting Winning/Losing streak it wants to go from W3 to L0. I also have to account for Ties and Byes to continue streak.
Thanks for any assistance. I've used a few of the solutions from here in this current workbook and others, so thanks for those as well.
Bookmarks