Ranking Results as, first, second, etc

[Jhertilus]

Ranking numbers

Please see attached sheet rankingexample.xlsx

Column A lists scores
Cloumn B lists names
I want Column C to rank the scores as first second third etc ( up to 100 ) with the highest number being first second highest being second.

[XOR LX]

Hi,

How do you want your ranking system to deal with ties?

Regards

[Jhertilus]

Holy cow I didn't think of that..... is it possible that in the case of two people finishing second, they both get a 2nd ranking and the next person gets 4th?

Or the tie breaker could be whomever comes first on the alphabet in column 2

[XOR LX]

Actually the first is quite easy as that's precisley what the RANK function does. So, in cell C2 of your sheet:

=RANK(A2,$A$2:$A$5,0)

and copy down as required. Obviously amend the range (A2:A5) to suit your needs.

Different matter if you want to split tie-breakers?

Regards

Edit: if you do amend the range, make sure you keep the $ signs in, as in my formula - just change the start and end numbers.

[martindwilson]

here are a few ways

[Jhertilus]

perfect, worked like a charm, thank you!