The jist of what I'm trying to do is rank a set of items automatically based on a score they're given.
It's for a personal evaluation of students, so in field C6 it will add their name, and in D6 the score. D6 contains the previous formula.
I've set it up to rank the scores already with the formula: =LARGE($G$13:$L$13,B6), B6 and down being the number in the list. It works very well.
I'm having issues with retrieving the name from the field in which the scores are tied to.
An example would be "Doe, John" is cell J5, while his score is at J13.
Is there a simple way to accomplish what I want, or will I have to do a really convoluted non-dynamic set of IFs or something?
Thanks for the help!
Bookmarks