Hello everyone
Hope you can help. I have a LONG list similar to the following:
Column A....Column B...........Column C
Name.........Total Score.......Average Score
A...............460.................20.0
B...............414.................18.0
C...............460.................22.4
etc etc
What I need to do is determine the name of the winner based on Total Score, but if there is 2 or more people that have the same total score (such as Names A & C in the example above) I need Excel to identify the winner based on the higher average (e.g. Name C). I don't want to use the sort function as I need to identify 1st & 2nd place on a separate worksheet within the workbook.
Is there a formula to do this? This one has me stumped.
Many thanks
Bookmarks