Hi all,
I'd like to find a way to rank items (in my case "days old") so that if there are two entries ranked "5", the first entry would be 5 and the second would be 6. Right now Ranking function gives me 1,2,3,4,5,5,7,8 etc. because there are two entries marked "5". I don't care which one of the 5 ranks is changed to 6, I just don't want duplicate rankings (rather have 1,2,3,4,5,6,7,8). In some case there might even be 10-20 of the same rankings.
Any help would be greatly appreciated.
Welcome to the forum!
Have a look here: https://www.extendoffice.com/documen...ique-rank.html
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Sorry, I actually tried the formula from the link you sent before: =RANK(Ap4;$AP$4:$AP$1318;0)+COUNTIF($AP$4:AP4;AP4)-1
However, I'm working with a table and when I try to translate that formula above into the table, I'm lost. I think the issue is just that I'm working with tables, not that the formula is flawed. Any help on how to translate above into a table (with [at[fieldname]] or some such wording?
It should make no difference. Attach the workbook.
Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
There is a bit of an issue with $A$2:A2 type references and structured tables. You need to adapt slightly!!
So, this formula:
=RANK($A2,$A$2:$A$15,0)+COUNTIF($A$2:A2,$A2)-1
needs to become like this:
=RANK([@Score],[Score],0)+COUNTIF(INDEX([Score],1):INDEX([Score],ROWS($1:1)),[@Score])-1
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi Glenn,
You rock! That worked like a charm! Exactly what I was looking for. Thanks so much!
(AligW: I'll remember next time to just lead with an attachment. Still learning the path here a bit.)
Thanks everyone for such prompt and helpful advice and answers!
Rohan
That's always a good idea!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks