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

Ranking agents considering multiple values.

pajju92

New Member
Hi Team,

Kindly help me to Rank agents considering attached values and given weightage.

there is no target for data & call handle, most handle agent should go up
Issues column impact to go down

80369
 

Attachments

  • Rank.xlsx
    13.5 KB · Views: 5
Then,

just change the formula sign from ">=" into "<="

And

the formula in H4 become, and copied down :

=SUMPRODUCT(0+(MMULT($B$2:$G$2*$B$4:$G$10,{1;1;1;1;1;1})<=SUMPRODUCT($B$2:$G$2*B4:G4)))

80399
 
Back
Top