View original (French)

How to adjust rankings in case of a tie

Solved
PYGOS69 Posted messages 452 Registration date   Status Member Last intervention   -  
Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   -
Hello,

I have a ranking that evolves continuously based on match results.

For example: if I have 3 players tied for 2nd place...

I want the players to be systematically shifted according to the score evolution...

meaning that places 3 and 4 should not be used even if players finished in 4th position (for example)

the file is available if needed...

I have used the RANK function to rank the players...

Excel 2003 SP3

Thank you in advance!

3 answers

  1.
    Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     
    Well yes!
    It will be infinitely easier to provide you with the explanation if we have your file...

    --
    Retirement is nice! Especially in the Antilles... :-)
    ? Raymond (INSA, AFPA, CF/R)?
    1
    1. PYGOS69 Posted messages 452 Registration date   Status Member Last intervention   21
       
      Thank you! But I couldn't find how to attach my file, please help me...
      0
    2. Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
       
      You had clearly stated, "the file is available"!

      The procedure appears in about 25% of the discussions on the Office forum...
      Go to https://www.cjoint.com/ to create the link, which you will then come back and paste here.
      0
    3. PYGOS69 Posted messages 452 Registration date   Status Member Last intervention   21
       
      Yes, I meant to say that I could contact him if needed... sorry, here is the link.. Thanks again!

      https://www.cjoint.com/?3FprylzUJYU
      0
  2. Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     
    Understood.

    First observation, your formulas in line 3 of Sheet1 are incorrect because you forgot to include the cell $D$2.
    Once the correction is made, the ranks are no longer
    5-9-2-2-5-6-2-8-6-1 but rather
    5-10-2-2-5-7-2-9-7-1

    Second observation, your statements do not correspond to the reality of your file:
    "I want the players to be systematically shifted according to the score; that is, positions 3 and 4 should not be used even if players finish in 4th position".
    This is already done, as you found 3 players in rank 2, no one in rank 3 or rank 4, and the next player was indeed in fifth place!

    Unless I misunderstood your problem ...

    It's nice, retirement! Especially in the Caribbean ... :-)
    ? Raymond (INSA, AFPA, CF/R)?
    0
    1. PYGOS69 Posted messages 452 Registration date   Status Member Last intervention   21
       
      Thank you!!
      0
  3. Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     
    Your formulas are long, which makes them difficult to decipher; but what is clear is that the formulas in AC3:AV3 do not resemble those in the other rows (from 2 to 11) at all! If you made them identical? I tried, and everything is perfect!

    That's one of the risks of hiding columns: you forget what's in them! Moreover, Excel was alerting you every time you opened the file, notifying you of a circular reference in AC3; you could have checked what was going on there!

    --
    Retirement is great! Especially in the Caribbean... :-)
    ? Raymond (INSA, AFPA, CF/R)?
    0
    1. PYGOS69 Posted messages 452 Registration date   Status Member Last intervention   21
       
      Yes indeed, the errors that I just corrected... And everything works! Thank you very much!
      0
    2. Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
       
      OK! See you next time...
      0