+ Reply to Thread
Results 1 to 8 of 8

How to remove tie in the excel rankings from weightage average scores

  1. #1
    Registered User
    Join Date
    03-02-2019
    Location
    Saudi
    MS-Off Ver
    2013
    Posts
    7

    How to remove tie in the excel rankings from weightage average scores

    Hello Excel Experts,

    I'm using MSFT 2013. It's a simple problem but I'm unable to fix it, though I consider myself an intermediate excel professional.

    The Background:

    1. I've got the weighted average scores from the scoring (Column L).
    2. Based on the weighted average scores, I've done the rankings (Column M).
    3. There is a tie in the rankings (# 1) because the scoring is same.

    The Problem:

    1. I want to remove the tie from the final rankings, so that I get all the ranking like 1,2,3,4,5 etc.

    Please help.

    I've attached the excel sheet for your information and ready reference.

    MBQ
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,065

    Re: How to remove tie in the excel rankings from weightage average scores

    RANK.EQ function might help, unless you have another method of deciding hierarchy?

    https://support.office.com/en-us/art...2-26245be04a40
    Please do add reputation where you see fit, it's nice to be nice and we all enjoy a pat on the back

    Please also mark your thread as solved once it has been.

  3. #3
    Registered User
    Join Date
    03-02-2019
    Location
    Saudi
    MS-Off Ver
    2013
    Posts
    7

    Re: How to remove tie in the excel rankings from weightage average scores

    I'm unable to solve my problem using your logic. May be I've not understood it correctly.

    Can you please solve it in the attached problem sheet?
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,065

    Re: How to remove tie in the excel rankings from weightage average scores

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    In Cell M4 and drag down

  5. #5
    Registered User
    Join Date
    03-02-2019
    Location
    Saudi
    MS-Off Ver
    2013
    Posts
    7

    Re: How to remove tie in the excel rankings from weightage average scores

    This solved the problem partially but if you noticed if you notice I'm still getting the same rank # 1 in row 12 & 16 of column M.

    See attached excel sheet and image.
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,065

    Re: How to remove tie in the excel rankings from weightage average scores

    So what is your another method of deciding hierarchy?

  7. #7
    Registered User
    Join Date
    03-02-2019
    Location
    Saudi
    MS-Off Ver
    2013
    Posts
    7

    Re: How to remove tie in the excel rankings from weightage average scores

    I really don't know how to decide on the ranking ties and eventually solve this problem. That's why I'm here in this forum.

    If you can solve the row 12 and 16 rank # 1 issue that would be great.

  8. #8
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,065

    Re: How to remove tie in the excel rankings from weightage average scores

    Quote Originally Posted by faisalmit1 View Post
    I really don't know how to decide on the ranking ties and eventually solve this problem. That's why I'm here in this forum.

    If you can solve the row 12 and 16 rank # 1 issue that would be great.
    You need to decide what factor will ultimately decide who is assigned the higher spot. Where values are equal even using Rank.EQ you will need to choose how you are going to rank them in the event of a tie

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1