LinkBack URL
About LinkBacks
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
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
rank unique instead
=RANK(B2,$B$2:$B$11,0)+COUNTIF($B$2:B2,B2)-1
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
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.
Last edited by icestationzbra; 10-01-2012 at 05:23 PM.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
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 ...
Originally Posted by 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.
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
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.
Last edited by icestationzbra; 10-01-2012 at 08:29 PM.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks