Paul,

You need a column of formulas on your other worksheet (preferably the first column of your table)
that ranks the scores. Then you can extract any information using VLOOKUP formulas, linked to that
first column, along the lines of

=VLOOKUP(Row(A1),Scoring!$A$1:$J$100,COLUMN(A1),FA LSE)

Copy that down and across, and you will get the table from Scoring, cells A1:J100, sorted in order.

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