How to rank?

S

Syahira

Let say if i have this data, instead of sorting, I want to rank from top to
bottom of the salesperson.

Salesperson Commission Ranking
A 58.79%
B 64.52%
C 60.58%
D 63.16%
E 77.08%
F 60.29%
G 66.36%
H 84.62%
I 74.85%
G 64.66%
K 72.02%
L 62.50%

How can I do it? Please help me and thank you in advance.
 
P

Pranav Vaidya

You can create a pivot table for this or use RANK worksheet function if using
Excel 2003.

Regards,
Pranav Vaidya
 
M

Mike H

Say your precentages are in Col B put this in C1.

=RANK(B1,B$1:B$20)

alter the B20 bit to match the length of the data in Column B and drag down
to the same length as Column B



Mike
 
P

Pranav Vaidya

Assuming you are using the formula in column C1
=Rank(B1,$B$1:$B$12)

Drag this formula till the end of list in column C

Regards,
Pranav Vaidya
 

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

Similar Threads

Copy and Paste Word 2010 0
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Rank and return Names 5
VLOOKUP/MATCH Query - quite complex....but interesting. 3
Formula Help 2
How do I make a rank equation that omits particular cells? 1
Sorting based on one column 1
How to determine the ranking positions? 3

Top