Rank data in variable range

On column A i have a list of sorted names, some of which are repeated in various cells on the same column A.
For each of the names in column A corresponds a number in column B.
What i would like to do is to rank the numbers found in column B in column C. But the ranking has to be done only across the same names in column A.

E.g
A1=x, B1=20
A2=x, B2=14
A3=x, B3=39
A4=y, B4=23
A5=y, B5=17

We should the ranking for the first three cells A1:A3 that all share the same name x, and a separate ranking for A4:A5 as they are equal to a different name (y). My difficulty is that the coordinates of the range are variable.

Hope this helps.

Thanks a lot!

Originally Posted by petsek

My difficulty is that the coordinates of the range are variable.

then you have code for fixed range

Originally Posted by patel45

sorry, I don't understand, but you can attach your code (better your file), i'll arrange for variable range.

do you want help me or not ?