+ Reply to Thread
Results 1 to 11 of 11

Ranking Based on Multiple Criteria

  1. #1
    Banned User!
    Join Date
    01-03-2020
    Location
    Germany
    MS-Off Ver
    Office365
    Posts
    1

    Lightbulb Ranking Based on Multiple Criteria

    96C002CC-8958-4585-A2E3-97D31C27E588.png

    Hi,

    I am in a strange situation about an EXCEL formula, have spent nearly 10 hours to find something for it, but could not achieve what I wanted to.

    May be you can help.

    The below photo will explain you my concern.

    Rank in Column E should be based on the combination of values in Column A, Column B, Columns C and the absolute value in Column D.

    E.g. Row 1 to 17, Column-D had a value of 7 (Row 7 - 13) which is the highest for the Project-1 (Column C)

    Similarly Row 18 - 32, Column-D had a value of 8 (Row 20 - 27)) which is the highest for the Project-2 (Column C)

    The expected outcome is shown in column E (TOP Z).

    Any Guidance?
    Last edited by AliGW; 07-05-2022 at 03:21 AM. Reason: Title changed - please think more carefully about your thread titles in future!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    63,803

    Re: Ranking Based on Multiple Criteria

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

    Administrative Note:

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. As you are new here, I have done it for you this time.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Registered User
    Join Date
    09-11-2013
    Location
    Germany
    MS-Off Ver
    Office365
    Posts
    3

    Re: Ranking Based on Multiple Criteria

    A sample table is shown below. The first 4 columns are data columns and the 5th column is the expected outcome.

    Status Assigned To Name? Project Count of Tickets EXPECTED OUTCOME???
    Open Name-1 (P1) Project-1 2 4
    Open Name-1 (P1) Project-1 2 4
    Open Name-2 (P1) Project-1 3 3
    Open Name-2 (P1) Project-1 3 3
    Open Name-2 (P1) Project-1 3 3
    Open Name-3 (P1) Project-1 7 1
    Open Name-3 (P1) Project-1 7 1
    Open Name-3 (P1) Project-1 7 1
    Open Name-3 (P1) Project-1 7 1
    Open Name-3 (P1) Project-1 7 1
    Open Name-3 (P1) Project-1 7 1
    Open Name-3 (P1) Project-1 7 1
    Open Name-4 (P1) Project-1 2 4
    Open Name-4 (P1) Project-1 2 4
    Open Name-5 (P1) Project-1 4 2
    Open Name-5 (P1) Project-1 4 2
    Open Name-6 (P1) Project-2 3 3
    Open Name-6 (P1) Project-2 3 3
    Open Name-7 (P1) Project-2 8 1
    Open Name-7 (P1) Project-2 8 1
    Open Name-7 (P1) Project-2 8 1
    Open Name-7 (P1) Project-2 8 1
    Open Name-7 (P1) Project-2 8 1
    Open Name-7 (P1) Project-2 8 1
    Open Name-7 (P1) Project-2 8 1
    Open Name-7 (P1) Project-2 8 1
    Open Name-8 (P1) Project-2 5 2
    Open Name-8 (P1) Project-2 5 2
    Open Name-8 (P1) Project-2 5 2
    Open Name-8 (P1) Project-2 5 2
    Open Name-8 (P1) Project-2 5 2

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    63,803

    Re: Ranking Based on Multiple Criteria

    Please attach a sample workbook.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

    Why have you opened two user accounts?

    I've put a ban on the pawiair2 account.

    Are you in India or Germany? Which version of Excel are you using?
    Last edited by AliGW; 07-05-2022 at 06:05 AM.

  5. #5
    Registered User
    Join Date
    09-11-2013
    Location
    Germany
    MS-Off Ver
    Office365
    Posts
    3

    Re: Ranking Based on Multiple Criteria

    Hello AliGW,

    I am from Germany.

    No issues about closing Pawiair2.

    The attachment TEMP111.xlsx is now attached. Hopefully this will work.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    63,803

    Re: Ranking Based on Multiple Criteria

    Please update your forum profile - your location currently says India, not Germany, and your Excel version says 2003, not MS365.

    I will have a look at the workbook.

  7. #7
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,743

    Re: Ranking Based on Multiple Criteria


  8. #8
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,294

    Re: Ranking Based on Multiple Criteria

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    Pepe Lo Mokko has provided the link for you. Meantime please read all of our rules before posting again.
    Jeff
    | | |?| |?| |?| |?| | |:| | |?| |?|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  9. #9
    Registered User
    Join Date
    09-11-2013
    Location
    Germany
    MS-Off Ver
    Office365
    Posts
    3

    Re: Ranking Based on Multiple Criteria

    Hello 6StringJazzer,

    Point taken, Rules understood. Sorry to say that but I had no clue that Chandoo and Excelforums are connected in any way.

    Thanks anyways for informing me about and I shall take care of it.

  10. #10
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,294

    Re: Ranking Based on Multiple Criteria

    Quote Originally Posted by pawiair View Post
    I had no clue that Chandoo and Excelforums are connected in any way.
    They are not connected. The rule is that if you post the same question anywhere else on the Internet that you give us a link to it. Otherwise you are going to have people duplicating effort and possibly working hard for you to solve a problem that was already solved.

  11. #11
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,958

    Re: Ranking Based on Multiple Criteria

    With a pivot table, see the attahced file (sheet PT).
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. Replies: 0
    Last Post: 01-04-2021, 04:41 PM
  2. Hello Champs
    By arunvirgo2003 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 03-23-2017, 07:59 AM
  3. Ajouter des champs vides dans une numérotation
    By redsonia in forum Non English Excel
    Replies: 2
    Last Post: 07-16-2015, 08:41 AM
  4. Replies: 9
    Last Post: 10-16-2014, 07:46 AM
  5. [SOLVED] help with calling a function (B) and return control of program flow to the calling functio
    By john/nyc in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-26-2012, 11:06 AM
  6. [SOLVED] Find Product Details in Another Sheet based on Product ID and Copy some Fields From there
    By kevalkothari in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-29-2012, 10:43 AM
  7. 2 question for Excel champs ;)
    By hummiz in forum Excel General
    Replies: 6
    Last Post: 06-02-2005, 12:56 AM

Tags for this Thread

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