# Calculating scores & ties

Copper Contributor

# Calculating scores & ties

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

=INDEX(D5:D23,MATCH(MAX(F5:F23),F5:F23,0))

TIA

3 Replies

# Re: Calculating scores & ties

``=FILTER(A2:A8,B2:B8=MAX(B2:B8))``

# Re: Calculating scores & ties

``=INDEX(\$D\$5:\$D\$23,MATCH(1,(\$F\$5:\$F\$23=LARGE(\$F\$5:\$F\$23,ROW(A1)))*(COUNTIF(\$B\$7:B7,\$D\$5:\$D\$23)=0),0))``

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.

# Re: Calculating scores & ties

For Winner(s):

``=LET(win_per,wins/(wins+losses),FILTER(names,MAX(win_per)=win_per))``

For Loser(s)

``=LET(win_per,wins/(wins+losses),FILTER(names,MIN(win_per)=win_per))``