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..
Bookmarks