Multiple results found in Index/Match formula, but I need the next value

[kgowett]

I'm trying to rank names based on score. My problem is, I have 6 people with 100% score, & it's returning 6 rows of the same person's name & none of the others who scored 100%.

How can I make it get the next person on the list from range O7:P18 ?

I'm assuming some sort of IF or OFFSET, but I'm not finding the resolution I need.



I've researched many posts and have learned that Index/Match is best suited for the task, so the formulas I have are:

My lists are Names in column O Scores in column P

H28(Returns Name) =INDEX(O7:O18,MATCH(I28,P7:P18,0),1) I28(Returns Score) =LARGE(P7:P18,1)

The list continues down, adjusting LARGE for 1, 2, 3... so on down to 12 from my list.


I've also tried to just change:
=INDEX(O7:O18,MATCH(I28,P7:P18,0),1)
to
=INDEX(O7:O18,MATCH(I28,P7:P18,1),1)
Which pulls the next person with 100%, but it only works on one row & it starts duplicating THAT persons name for the remaining 4 rows.