I assume you want to use something to present a sorting order even with ties in the scores?

If so: you have to add a very little number 'behind the scenes' to the results, so Excel can sort them. This is mostly done by taking the rownumber and divide that with 1000 or such. 

If this is what you are looking for we probably can provide you an example.

Frans

yes please.

I'll come back on this in one or two days from now, sorry but I'm a bit busy at the moment.

Suppose my scores with duplicates are in B3:B19. I can get simple ranks if in C3:C19 I use the formula

=RANK(B3,B$3:B$19)

But duplicate scores will have the same rank, and then the next rank number will be unused.

You can use a simple modification to the formula, without adding a "small" value (because what you thought was a small enough value might not be if the values all become very small):

=RANK(B3,B$3:B$19)+COUNTIF(B$3:B3,B3)-1

The COUNTIF adds 1 each time the value in column B occurs in that row or higher in the list. You need to subtract 1 because COUNTIF adds 1 for the first occurrance.