Need help on scoring

  • Thread starter Thread starter Marier
  • Start date Start date
M

Marier

Hi

I have a table like this:

A B C D
Albert Charles Mary Nancy ->names
5 2 1 4 ->values
3 9 4 8 ->values
-------------------------------------------
8 11 5 12 ->totals

I want to know who has the higher total. This is easy on this example,
because there are only 4 persons... but my real table has over 50.
How can I quickly list the best score and who reached it.
I need to rank that no.1 sales person is Nancy, with 12 points, second best
is Charles, with 11 points.
I have different sheets (for each month) and accumulative totals in each
sheet.
Need to know who's the best sales person (name and highest score), per
month, and totally (accumulative).
Have tried many formulas, but I get N/A errors.... Please help.
 
I Assume that the total is in A4 to D4 and the names are in A1 to D1 cells.

Try this formula
=A1&" "& RANK(A4,$A$4:$D$4)

OR

=RANK(A4,$A$4:$D$4)


Remember to Click Yes, if this post helps!
 
Back
Top