Results 1 to 6 of 6

Ranking the 1st places, 2nd places and 3rd places

Threaded View

  1. #1
    Registered User
    Join Date
    06-28-2022
    Location
    canada
    MS-Off Ver
    office 2019
    Posts
    4

    Ranking the 1st places, 2nd places and 3rd places

    So I have 3 tables where each table consists of 3 teams.

    I made a formula to rank each of the teams in each table in the order of :
    1. Points
    2. Goal Difference
    3. Score For

    and after all 3 tables were completed, I made a table where I put all the rankings together.

    Now I need help making a formula where I rank all the 1st places separately, 2nd places separately and 3rd places separately. Using the same order,
    where first it would look at their "points", and if "points" are tied then look at "goal difference", and if that's also tied then look at the "score for".
    and if all 3 of those things are tied then it's okay for two teams to finish with the same rank.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 07-09-2022, 12:23 PM
  2. Adusting decimal places based on greatest number of places in a series
    By anelson87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2022, 01:05 PM
  3. Decimal Places
    By rmccain in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-23-2016, 10:05 PM
  4. [SOLVED] Ordinal Ranking or places, allowing ties after soring scores
    By JMacrow in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-10-2012, 02:07 PM
  5. Replies: 2
    Last Post: 03-30-2012, 12:34 PM
  6. Excel 2007 : Places Bar
    By MilusC in forum Excel General
    Replies: 1
    Last Post: 04-23-2010, 12:29 PM
  7. [SOLVED] decimal places
    By Simon0009 in forum Excel General
    Replies: 2
    Last Post: 06-03-2005, 02: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