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...
=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.