+ Reply to Thread
Results 1 to 2 of 2

Ranking Issue

  1. #1
    Registered User
    Join Date
    01-17-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    22

    Ranking Issue

    Hi All,

    Kindly help me a solution for this dashboard, Mr Newdoverman gave a solution last time hence do not want to pester him again ,an other person kindly pls provide a solution

    Problem :

    •Ranking based on multiple criterion
    •Ranking should such that it follows the following sequence : 1)ME 2)HVSB 3)HGSB 4)MMSB 5) Others
    •the products are ranked based on revenue contribution which is in coloum G of the spread sheet
    •All the team leader who have RM who contribute high revenue by selling ME product should be ranked 1st
    •Only when all the ME product is ranked & exhausted the subsequent product needs to be ranked
    •The team leader & his RM should remain intact , even if the other Rm’s have other products they should remain with the same team leader but should be ranked under the same team leader in the sequence above.

    Regards
    Gamefreak
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-17-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Ranking Issue

    Hi Newdoverman ,

    Incase you are viewing the post its the logic but your previous logic when I applied to this file it did work , ranking difficult as your pervious formula was based on no of client column , the same approach is not working when applied to higher volume data. The ranking should use YTD income coloumn as they represent the actual revenue contribution of each product to the Team leader

    Regards
    Gamefreak
    Last edited by gamefreak; 12-02-2014 at 01:05 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help with #value! issue in ranking formula
    By BitterGreg in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-14-2014, 04:13 PM
  2. [SOLVED] Ranking & Scoring Issue
    By k2sul in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-10-2013, 10:33 AM
  3. Ranking (weighted) issue
    By jw01 in forum Excel General
    Replies: 4
    Last Post: 09-07-2011, 08:10 PM
  4. Ranking Issue
    By IdRatherBeCoding in forum Excel General
    Replies: 2
    Last Post: 05-23-2011, 11:28 AM
  5. Ranking Issue
    By acg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-11-2007, 05:28 PM

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