Sorry I'm new at this, can you show me how to use RANK?


"Pranav Vaidya" wrote:

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

Regards,
Pranav Vaidya

"Syahira" wrote:

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.