Top 10 Ranking

[Figboot]

What am I doing wrong here. Whenever I have a tie in my rankings, my top 10 list shows #na. I know that it's something simple, but I just can't see the issue.

Thanks...

[TonyB51]

Hi,

The problem seems to be when you have duplicate values in your overall total.

By adding a new column I have been able to establish unique values.

See what you think.

Cheers

Tony

[zbor]

Nice Tony...

I would just add to your solution:

For extra column you can use also this: =F3+COUNTIF($F$3:F3,F3)/100

For table ROWS function is better: INDEX($J$3:$J$79,MATCH(ROWS($B$3:B3),$H$3:$H$79,0)

Edit: Also, not clear what if there's more people with Total 68 (in this example)... Here is first one prefered (Rick Hardin)... What with others?

[DonkeyOte]

This can be achieved without helpers if preferred ?

C3: =SMALL($F$3:$F$79,ROWS(C$3:C3))
copied to C12

B3: =INDEX($I$3:$I$79,MATCH(1,INDEX(($F$3:$F$79=$C3)*ISNA(MATCH($I$3:$I$79,$B$2:$B2,0)),0),0))
copied to B12

[rwgrietveld]

... and would you use a counta(H:H)-1 instead of
=LOOKUP(9.99999999999999E+307,H:H)?

[Figboot]

Thanks everyone...I appreciate it.