Display the max, then the next down, then the next down, etc.

Another question relating to ranking. Does anybody know of an easy formular
to show a ranking by showing the max (#1) at the top, then the next down (#2)
under it, then the next down (#3) under that, and so on? In my example, it
would be finding the values from another work*** in the same workbook. For
example:

Student Test Grade Rank
Meep 100% 1
Batman 98% 2
Superman 97% 3
Willy Wonka 95% 4
Veruca Salt 43% 5

So, in this example, it is getting "Test Grade" and "Student" from another
work***. Any formula that would be able to do this? Anything that could
pull over the top test grade to put next to rank # 1, as well as that
person's name, then the second highest test grade and the person's name next
to rank #2, and so on? (Note: My spread*** isn't actually using test
grades, that is just the example I'm using.)

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy
.

Loading