"Bernie Deitrick" wrote:

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),F ALSE)

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

I'm not sure that I understand. What kind of formula would I need to rank
the scores? That is part of my question to begin with. I'm trying to figure
out how to get it to associate each score with an appropriate rank based on
the other scores. You've told me how to get it to list the way I displayed
once I have them ranked, but I still don't understand how to assign each one
a rank to begin with. If you answered that, I don't understand.

"Bernie Deitrick" wrote:

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.

Just out curiosity, how would I do this? Oh, also, what if a tie were
allowed in some of the fields? So, for example, say several people could be
tied for number one in average test score and attendance. Would there also be
a way of doing this. Here is an example of what I'd want if that were the
case:

Student Test Grade Rank
Meep 100% 1
Batman 100% 1
Superman 100% 1
Willy Wonka 95% 4 (or 2, if that makes it easier)
Veruca Salt 43% 5 (or 3, if that makes it easier)

Also, just an interesting unrelated question open to all: I'm interested in
your opinion on a situation like the example above. When three people are
tied for number 1, does that make the next person down number 2, or number 4?
Technically, it is the second highest score, but it is the fourth ranked
person, it just so happens the first three are tied.


--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy