Hi

I am trying to adapt the COUNTIF FUNCTION to assign ranks without skipping a rank number e.g. if I have 6 people with 4 unique scores and 2 tied scores scores I want the ties to be given the same rank and the rank to be from 1-4 rather than 1-6as below:

Eg
score rank
Mr A 6 4
Mr B 10 1
Mr C 8 2
Mr D 7 3
Mr E 10 1
Mr F 7 3

Is this possible?

Thanks for your help.