+ Reply to Thread
Results 1 to 6 of 6

Descending ranking based on two scoring sessions

  1. #1
    Forum Contributor
    Join Date
    03-11-2009
    Location
    Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    247

    Descending ranking based on two scoring sessions

    Hi,

    I'm having trouble solving rating problems with other models such as sorting the rankings from the smallest value of the combined two scores (two sessions)... for more details, see the attachment, thank you for all the help,

    Regads.
    Last edited by herukuncahyono; Yesterday at 06:46 AM.

  2. #2
    Valued Forum Contributor dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    Microsoft Office 365
    Posts
    1,067

    Re: Descending ranking based on two scoring sessions

    It may be just me, but i am confused what you are basing your ranking results in column I by. I tried summing scores 1 and 2 but the rankings don't make sense with how you want them. Can you try elaborating a little more.
    <----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.

  3. #3
    Forum Contributor
    Join Date
    03-11-2009
    Location
    Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    247

    Re: Descending ranking based on two scoring sessions

    Hi dosydos,

    The question is the formula in column F... And in column I that is the result it should be (I filled it manually, not from the formula,but by sorting combination scores 1 and 2 and skipping preexisting names or no duplication )
    BTW, I have included the manual calculation below

    #actually the score of the data value in seconds (duration) so whoever is the fastest (the smallest value) is the highest rating

    Regrads
    Last edited by herukuncahyono; 06-23-2022 at 08:02 PM.

  4. #4
    Forum Contributor
    Join Date
    11-21-2013
    Location
    zimbabwe
    MS-Off Ver
    Excel 2003
    Posts
    103

    Re: Descending ranking based on two scoring sessions

    Try in F5
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    03-11-2009
    Location
    Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    247

    Re: Descending ranking based on two scoring sessions

    Hi soledad,
    Thank you for helping to solve my problem

    regards

  6. #6
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Malaysia
    MS-Off Ver
    365 & WPS(2022)
    Posts
    2,020

    Re: Descending ranking based on two scoring sessions

    Cell F5 formula , Drag down

    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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. simple ranking / scoring system
    By tunachi in forum Excel General
    Replies: 2
    Last Post: 02-25-2019, 07:14 AM
  2. Ranking, or Ordering in Descending Order
    By sighlent1 in forum Excel General
    Replies: 4
    Last Post: 09-26-2018, 10:34 AM
  3. Ranking & Scoring
    By prudential in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-08-2015, 01:24 AM
  4. Using percentage scoring with ranking
    By momiieee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2014, 05:13 PM
  5. [SOLVED] Ranking & Scoring Issue
    By k2sul in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-10-2013, 10:33 AM
  6. Excel 2007 : Disc golf scoring and ranking
    By trichard311 in forum Excel General
    Replies: 0
    Last Post: 02-07-2012, 05:43 PM
  7. Scoring/Ranking 2 Columns of Stock Symbols
    By Bohica in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-01-2006, 02:20 AM

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