So I am making a bowling stats spread sheet and am stuck with the last part of it. I need to look at all the scores of everyone in the league and return the persons name and score of the highest, 2nd highest, 3rd highest, and 4th highest for men and women
Right now I have the following times 10 teams
gender Team #1
m Jim 123 213 134
m Hank 166 111 215
m John 222 213 197
f Paula 100 145 98
f Jane 210 168 153
I have used the MAX formula to find the max value but cannot figure out how to display the name of the person who bowled that max value.
Any Help would be appreciated.
Right now I have the following times 10 teams
gender Team #1
m Jim 123 213 134
m Hank 166 111 215
m John 222 213 197
f Paula 100 145 98
f Jane 210 168 153
I have used the MAX formula to find the max value but cannot figure out how to display the name of the person who bowled that max value.
Any Help would be appreciated.