• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Combine Rank and Tunc function for scoring 1-10

M

MichaelBuechler

New Member
Hi guys

I'm trying to score the priorities across a range of budgets and by 1-10 and was coming up with this solution;

=RANK($B2, $B$2:$B$9)
=TRUNC(C2/($A$2+1)*10)

upload_2017-4-7_9-45-53.png

Is there a solution on how to combine the above two formulas?
Looking forward to your solution!

Michael
 
Last edited:
MichaelBuechler said:
Hi guys

I'm trying to score the priorities across a range of budgets and by 1-10 and was coming up with this solution;

=RANK($B2, $B$2:$B$9)
=TRUNC(C2/($A$2+1)*10)

View attachment 40471

Is there a solution on how to combine the above two formulas?
Looking forward to your solution!

Michael
Click to expand...
Hi Michael

Good noon :)

See if this is what you are looking for..

=TRUNC(RANK($B2,$B$2:$B$9)/($A$2+1)*10)

Regards
Jaya
 
Hi Jaya

Good afternoon! :)

Great - just worked fine; changed the +1 to the end of the formula; =TRUNC(RANK($B2,$B$2:$B$21)/($A$2)*10)+1 and it just made its trick!

Very much appreciated!!!
Have a great weekend,
Michael
 
MichaelBuechler said:
:) If The highest ranked budget scores 1 then 1 = 10 and the lowest ranked budget would score 1.
Click to expand...
So you basically need the top ten ranked but in descending order.. Right?

=RANK(B9,$B$2:$B$21,0)+COUNTIF($B$2:B9,B9)-1

Try this out. but this also is running over 10.
 
Last edited:
You must log in or register to reply here.
Back
Top