Hi,

As below, I am trying to calculate if my team ("Team A) won, lost or drew.

Col A - I have put this in to show you what I mean, but that's the column I want to automate by looking at each teams scores and what they got. I want to do it all with respect to team A though. Is any one able to help me!? Thanks.

Col A Col B Col C Col D Col E

L Team A 56 Team B 139
L Team B 166 Team A 44
D Team A 56 Team B 56
L Team A 28 Team B 111
W Team B 105 Team A 102
L Team B 171 Team A 72
W Team A 72 Team B 63