I have read many postings on ranking and they don't seem to make sense to me,
that is why I supppose I am here. :) I need a formula that will sort store
rankings based on the highest average score and the highest plus "plus/minus
score". Here is some of the information:

Column A3:A21 is the store numbers
Cloumn X3:X21 is last week average (percentages)
Column Y3:Y21 is this week average (percentages)
Column Z3:Z21 is plus or minus vs last week average (percentages)

Now in column C28, which is rank 1, I want the store number (A3:A21) to show
up in C28 based on it having the Highest average score which is in column
Y3:Y21 and the corresponding score (Column Y3:Y21) show up in D28. Then to
repeat the ranking for C29 and D29 for rank 2 and so on up to the top 5. The
plus/minus I am sure will be the same type of formula. In column F28, which
is rank 1, I want the store number (A3:A21) to show up in G28 based on it
having the greatest improvement which is in Column Z3:Z21 and the
corresponding score (Column Z3:Z21) show up in G28. Then to repeat the
ranking for F29 and G29 for rank 2 and so on up to the top 5.

Thanks for all that will help!

I have figured out how to get the numbers to rank in order by using the large
function for example

=LARGE($Y$3:$Y$21,1)
=LARGE($Y$3:$Y$21,2)
=LARGE($Y$3:$Y$21,3) and so on now I am trying to figure out how to get the
information from column A3:A21.


"YS1107" wrote:

I have read many postings on ranking and they don't seem to make sense to me,
that is why I supppose I am here. :) I need a formula that will sort store
rankings based on the highest average score and the highest plus "plus/minus
score". Here is some of the information:

Column A3:A21 is the store numbers
Cloumn X3:X21 is last week average (percentages)
Column Y3:Y21 is this week average (percentages)
Column Z3:Z21 is plus or minus vs last week average (percentages)

Now in column C28, which is rank 1, I want the store number (A3:A21) to show
up in C28 based on it having the Highest average score which is in column
Y3:Y21 and the corresponding score (Column Y3:Y21) show up in D28. Then to
repeat the ranking for C29 and D29 for rank 2 and so on up to the top 5. The
plus/minus I am sure will be the same type of formula. In column F28, which
is rank 1, I want the store number (A3:A21) to show up in G28 based on it
having the greatest improvement which is in Column Z3:Z21 and the
corresponding score (Column Z3:Z21) show up in G28. Then to repeat the
ranking for F29 and G29 for rank 2 and so on up to the top 5.

Thanks for all that will help!