Forum Discussion
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...
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))