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

1. ## 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

2. ## 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

3. ## 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?

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

Formula:
`Please Login or Register  to view this content.`

In Cell M4 and drag down

5. ## 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.

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

So what is your another method of deciding hierarchy?

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. ## Re: How to remove tie in the excel rankings from weightage average scores

Originally Posted by faisalmit1
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

#### Thread Information

##### Users Browsing this Thread

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

#### 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