If there are ties for second place then there is no third place
assume the values are in B1:B6

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


copy down

--


Regards,

Peo Sjoblom


"Thrava" wrote in message
...
Hello folks,

I have a list of about 350 sales reps. I like to be able
to rank them automatically based on the numbers that
appear in front of their name in column B.

These numbers are in percent with one decimal point
accuracy.

some of the reps of course have the same percent so they
need to be given the same ranking.

Example
Name percent Rank
Sharif 78.4% 1
Aljandro 66.9% 2
Flora 66.9% 2
Yusef 59% 3
John 48% 4
Anna 48% 4

What formul in the column for ranking can I use to
automate this please?