L
LCentioli
I'm using data in one sheet to create rankings in another sheet.
However, if there are duplicate values, it only returns the first
matched value. For example...let's say im a teacher and am keeping
track of my student's test grades. One sheet has the raw data (name
and grade). The other sheet is ranking these students based on their
grade, using the LARGE function, and matching these grades to students
using INDEX MATCH. Now let's say two students got a 90 (A1=John and
B1=90, A5=Joe and B5=90). It's returning John's name twice because he
is at the top of the list. How can I get both John and Joe's names to
each show up with their grade of 90?
However, if there are duplicate values, it only returns the first
matched value. For example...let's say im a teacher and am keeping
track of my student's test grades. One sheet has the raw data (name
and grade). The other sheet is ranking these students based on their
grade, using the LARGE function, and matching these grades to students
using INDEX MATCH. Now let's say two students got a 90 (A1=John and
B1=90, A5=Joe and B5=90). It's returning John's name twice because he
is at the top of the list. How can I get both John and Joe's names to
each show up with their grade of 90?