advanced function

[dastr]

Hi all,

I have the below table:

Name	Score
Anna	2
Luisa	4
Luisa	3
Angel	1
Angel	8
Angel	7
Angel	5
Arlene	1

And my output should be something like this (Column BEST)

Name	Score	BEST
Anna	2	1st best
Luisa	4	2nd best
Luisa	3	1st best
Angel	1	1st best
Angel	8	4th best
Angel	7	3rd best
Angel	5	2nd best
Arlene	1	1st best

The logic – if the name is the same (appears more than once), we need to look in the second column and compare the score, the lower the score, the higher “the best”. For example, if we have a single entry like Anna – it automatically becomes 1^st best, in Luisa’s case (appears twice)– the lower score 3 is the 1^st best; 4 is the 2^nd best, etc, we can have only 1^st,2^nd,3^rd and 4^th best.
Does anyone have any idea how I may achieve this? – getting column BEST?

Thanks you in advance.

[pbaldy]

Looks like basic ranking:

http://allenbrowne.com/ranking.html