I found this formula online and it works well to decide if a team has a win or loss, but I am trying to create a last 10 GP record, win/loss streak columns, a column that displays a teams home/Away record, and also trying to separate losses between regulation and OTL.
I am new and am not sure how to post the formula, but this is it
=SUMPRODUCT((Fixtures[Home Team]=Calculations!$C3)*(Fixtures[Away Score]>Fixtures[Home Score2])+(Fixtures[Home Score2]>Fixtures[Away Score])*(Fixtures[Away Team]=Calculations!$C3))
I can use it to determine win and loss columns. Any help will be appreciated.
Bookmarks