Paul,

Oh, I also forgot to mention that you need to ensure that you have a tie-breaking mechanism in place
for the VLOOKUP solution (in my previous post) to work.

HTH,
Bernie
MS Excel MVP


"Paul (ESI)" wrote in message
...
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 worksheet 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
worksheet. 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 spreadsheet 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