+ Reply to Thread
Results 1 to 8 of 8

Ranking two variables

  1. #1
    Registered User
    Join Date
    08-14-2014
    Location
    London, England
    MS-Off Ver
    MS Office 10
    Posts
    69

    Ranking two variables

    Hi there,

    I was wondering if someone would be able to help with a ranking formula I am trying to do.
    I have attached a sheet which shows the problem I'm trying to solve.
    I have a list of names and the "class" that each name belongs to. I then have scores / ranks for each day of the week (some of the ranks are the same!)
    In column L I have a data validation so I basically just want to be able to select the day and select the class and have it return the list of names and their rank for that day. So for example, if I selected Tuesday and Class A, it would automatically show the 4 names (& order) I have shown in the picture in green.

    Hopefully this makes sense and you can sort of understand what I'm getting at!
    Any help would be so appreciated.
    Thanks everyone.



    Sam
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,806

    Re: Ranking two variables

    What criteria do you wish to use for ranking when there are identical scores? Jack and Owen are the same on Tuesday.

  3. #3
    Registered User
    Join Date
    08-14-2014
    Location
    London, England
    MS-Off Ver
    MS Office 10
    Posts
    69

    Re: Ranking two variables

    Hi Flame, thanks for your reply.
    Is it possible to have them so they are equal ranks? So both of them have a rank of 3?
    I know my table in green showed 3 and 4.... ignore that!!
    Thank you

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,806

    Re: Ranking two variables

    Yes. I believe so.

  5. #5
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    2,244

    Re: Ranking two variables

    Hope this works, pls see the file attach

    regards
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2010
    Posts
    5,686

    Re: Ranking two variables

    Pl see attached file
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    08-14-2014
    Location
    London, England
    MS-Off Ver
    MS Office 10
    Posts
    69

    Re: Ranking two variables

    Thank you very much to both of you with those answers... very much appreciated

  8. #8
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,806

    Re: Ranking two variables

    Another slightly different approach; different results. Helper column P. Array entered.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Ranking column O.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Names column N.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    File is attached.

+ 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. Ranking values and ranking duplicates the same rank
    By 302arpks in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-05-2015, 01:50 PM
  2. Creating Unique Values on Ranking for with Two Variables
    By NicholasLRW1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-14-2013, 01:43 AM
  3. Ranking Data based on multiple variables...
    By jasonkbu in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-08-2013, 10:00 AM
  4. Ranking cities on Multiple variables
    By Learn2earn in forum Excel General
    Replies: 1
    Last Post: 08-24-2012, 11:58 PM
  5. A series of weighted variables for a percentage ranking
    By buzzzworthy in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-05-2010, 01: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