+ Reply to Thread
Results 1 to 5 of 5

Ranking teams in order based on points

  1. #1
    Forum Contributor
    Join Date
    08-29-2013
    Location
    CT
    MS-Off Ver
    Excel 2016 Mac
    Posts
    268

    Ranking teams in order based on points

    So i have a sheet that calculates total point for our field day and I would like it automatically populate the Rankings (Desired Results Sheet). I cannot figure out how to get it to put them in order with the team color and points matching.

    I would like to look like:

    Place Team Points
    1 Pink 69
    2 Green 64
    .
    .
    .

    and so on.

    Any help on this would be greatly appreciated i have attached a sample sheet.

    Los

    Field Day 2014 Sample.xlsx

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Ranking teams in order based on points

    =INDEX('Grades 7-8'!B$1:Q$1,MATCH(LARGE('Grades 7-8'!$B$15:$Q$15,'Desired Reults'!A2),'Grades 7-8'!B$15:Q$15,0))

    in B2 and

    =INDEX('Grades 7-8'!B$15:Q$15,MATCH('Desired Reults'!B2,'Grades 7-8'!B$1:Q$1,0))

    in C2 then copy down

  3. #3
    Forum Contributor
    Join Date
    08-29-2013
    Location
    CT
    MS-Off Ver
    Excel 2016 Mac
    Posts
    268

    Re: Ranking teams in order based on points

    For some reason i keep getting an error when i input it

  4. #4
    Forum Contributor
    Join Date
    08-29-2013
    Location
    CT
    MS-Off Ver
    Excel 2016 Mac
    Posts
    268

    Re: Ranking teams in order based on points

    Also how would could i have it list both teams when there is a tie?

  5. #5
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Ranking teams in order based on points

    Please see attached example
    Attached Files Attached Files

+ 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 teams ascending with formula
    By Bishonen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-26-2013, 05:43 PM
  2. Assign number based on sort order (Step Ladder points)
    By benjya in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-21-2012, 01:24 AM
  3. [SOLVED] Help to automate ranking of tied teams in sports scoring program
    By alan_stephen75@ in forum Excel General
    Replies: 30
    Last Post: 06-11-2012, 02:27 PM
  4. Awarding points in inverse order with continuous ranking
    By matty ice in forum Excel General
    Replies: 3
    Last Post: 05-04-2011, 05:51 PM
  5. [SOLVED] how to set up Bowls league 12 teams points and shot difference
    By Mel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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