Question about assigning position within group

[eat_cress]

Hi guys,

I was wondering if anyone could help me with something I am trying to do on Excel.

I am looking to see if you know of any way in which to assign someone their position number within a group.

Basically, there are a number of agents who have different scores, and I wish to know if there is a function that does this, so it would look like this:

Name............Score Position
Agent A ........94% ......2
Agent B ........82% .....5
Agent C ........98% .....1
Agent D ........88% ......4
Agent E ........90% ......3

I would need a formula to work out their position.

I hope I have explained myself well, and if not, I will try and explain it better.

Cheers

 

[Phanmore]

Check out the Rank Formula:

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