Calculating scores & ties

Copper Contributor

Hey! we have a little game and use excel to calculate wins and losses. 


I have cells which indicate the overall winner and the overall loser but I cant figure out how to put 'tie' if the there is a tie.


As is stands we have a 3 way tie for the winner and a tie for the loser but the formula i've got is just choosing a random name for the overall winner and overall loser.


Heres the formula I'm using for the overall winner/loser









3 Replies





An alternative with e.g. Excel 2013 could be this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. The formula is in cell B8 and filled down.





For Winner(s):


For Loser(s)