Need help on scoring

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.
 
M

Ms-Exl-Learner

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top