# Ranking and Breaking Ties

1. ## Ranking and Breaking Ties

Hi,

I'm having a real issue regarding ranking with multiple criterias on excel and I'm hoping I would get some help in this forum since I couldn't figure this out myself.

Basically, there's 2 ranking: One with 1 criteria as tie breaker and the other with 2 criterias.

RANK 1
Column A: Rank
Column B: Agent Name
Column C: Accuracy (percentage)
Column D: Evaluations (quantity) - Tie Breaker 1

RANK 2
Column A: Rank
Column B: Agent Name
Column C: Satisfaction (percentage)
Column D: Evaluations (quantity) - Tie Breaker 1
Column E: Answered (quantity) - Tier Breaker 2

I've tried Rank.EQ, CountIFs and SUMPRODUCT with no avail.

I would really appreciate if someone help me with this 'minor' headache..

2. ## Re: Ranking and Breaking Ties

Hello Sakrammentum. Welcome to the forum.

I am not sure how to interpret the instructions. I started here by resolving the ties in your existing formulas 'Plan2'. In cell A3 and filled down.
Formula:
`Please Login or Register  to view this content.`
In cell A10 and filled down.
Formula:
`Please Login or Register  to view this content.`
Is this helping?

3. ## Re: Ranking and Breaking Ties

Maybe in A3 sheet plan2:

``Please Login or Register  to view this content.``
Fill down

A10:

``Please Login or Register  to view this content.``
Fill down

4. ## Re: Ranking and Breaking Ties

Nope,

It returns an error, i've something like this and I appreciate the help FlameRetired.

5. ## Re: Ranking and Breaking Ties

Originally Posted by bebo021999
Maybe in A3 sheet plan2:

``Please Login or Register  to view this content.``
Fill down

A10:

``Please Login or Register  to view this content.``
Fill down
OH MY! These two did it and it worked perfectly well. Thank you bebo21999!

Could you explain what exactly this formula is doing so I can replicate without bothering you guys?

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