Forum Discussion
tbrit905
Jul 26, 2023Copper 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...
Detlef_Lewin
Jul 26, 2023Silver Contributor
=FILTER(A2:A8,B2:B8=MAX(B2:B8))