Hello Dear Friends,
Please refer attached spreadsheet. This is using count if and rank formula to rank values.
If a values repeats, the repeated values should share the rank. Please see attached sheet for better understanding. I use Excel 2003.
Thanks in advance
This will give you the ranking, it will give duplicate numbers the same rank, but will then skip the next number...
=IF(A3="","",RANK(A3,$A$3:$A$17,1))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
THanks FDibbins. I applied your formula. Repeated values do share the same rank, in this case, rank 2, but the next item is ranked as "4" instead of rank "3". I would like to rank the next item as "3" please see attached. Any chance to make this happen
Hi All,
I hope you'd get better solutions.
Please Login or Register to view this content.
Regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks