Locate Top 3 from a Range using Rank - Problem with Duplicates - Excel 2007

[exgrom]

Hi All,
Can any advise if there is a way of handling duplicates when using RANK?
The screenshot attached shows more clearly what i need?
Any help appreciated
Thanks
ExGrom
Problem.PNG

[martindwilson]

rank unique instead
=RANK(B2,$B$2:$B$11,0)+COUNTIF($B$2:B2,B2)-1

[icestationzbra]

your explanation left me ambiguous about what it is that you are looking for. do you want to or not want to show duplicates?

also it is preferred that you upload excel files instead of pictures.

[exgrom]

Many Thanks for the responses martindwilson & icestationzbra.
Both solutions produced good results.

Yes I want to show any duplicates.
I am developing the spreasheet as we speak so it is evolving and problems are popping up as I go, the joys of being a Excel newbie, it's all good learning curve.

Could you help with the attached, spreadsheet this time

Once again many thanks ...

your explanation left me ambiguous about what it is that you are looking for. do you want to or not want to show duplicates?

also it is preferred that you upload excel files instead of pictures.

[icestationzbra]

have you seen the file that i uploaded? it seems to be doing what you are asking for. check out the formulae embedded in the file to see how to adapt it to your workbook.

if that is not what you want, point out the difference and explain what it is that you would rather it did.

[exgrom]

Hi, thanks, yes it worked well, but this time i was wanting to bring back an additional adjacent column as well as the Score in your example.
Hope that makes sense!
It's late here so heading off for some zzzzzz's.
I will be carrying on with it tomorrow when hopefully I will be seeing things a little clearer

[icestationzbra]

on top of the forumale already provided in the earlier file (which you can adapt to your work file), the following formula will get you Actual in cell I2:

Please Login or Register  to view this content.

[exgrom]

hi, Many thanks for this, works well now, amany thanks!
Regards
exGrom

on top of the forumale already provided in the earlier file (which you can adapt to your work file), the following formula will get you Actual in cell I2:

Please Login or Register  to view this content.