View original (French)

Put in the correct order

Solved
gigipong Posted messages 128 Registration date   Status Member Last intervention   -  
gigipong Posted messages 128 Registration date   Status Member Last intervention   -
Hello,

I’m returning for a new request for help; the attached file should be sufficiently explicit, but if not, please let me know.

And I thank in advance the person or people who will assist me.

https://cijoint.org/r/JSQnhb4s#1faB7uCUOLnl2rov3+v60Dn7VjeBAD7TzTbuz0YNiag=

Best regards.

6 answers

  1.
    brucine Posted messages 24948 Registration date   Status Member Last intervention   4 179
     

    Hello,

    If there are only 2 matches in the first part, the complication escapes me.

    In G13 the smallest number in column D is returned by =MIN(D3:D4) which will face in I13 the largest in column B =MAX(B3:B4).

    In row 14 we reverse the formulas, =MIN(B3;B4) will play against =MAX(D3:D4)

    0
  2. gigipong Posted messages 128 Registration date   Status Member Last intervention   1
     

    Hello,

    There are 20 meetings but I just wanted to explain the principle.

    0
    1. gigipong Posted messages 128 Registration date   Status Member Last intervention   1
       

      In reality, I want to find the winners and losers first and then sort them: small team number against large number.

      0
      1. gigipong Posted messages 128 Registration date   Status Member Last intervention   1 > gigipong Posted messages 128 Registration date   Status Member Last intervention  
         
        I hope you understand that I want a single formula if possible.
        0
  3. danielc0 Posted messages 2195 Registration date   Status Member Last intervention   285
     

    Hello,

    With Excel 2024 or Excel 365, in B14 (winners):

     =DANSLIGNE(TRIER(MAP(B3:B4;D3:D4;E3:E4;LAMBDA(a;b;sc;IF(LEFT(sc;1)*1>2;a;b)))))

    In B15 (losers):

     =DANSLIGNE(TRIER(MAP(B3:B4;D3:D4;E3:E4;LAMBDA(a;b;sc;IF(LEFT(sc;1)*1>2;b;a)))))

     Daniel

    0
    1. gigipong Posted messages 128 Registration date   Status Member Last intervention   1
       

      Hello Daniel,

      Sorry, I don’t understand why B14 and B15.

      0
  4. via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     

    Hello

    A question: in case of a draw, who will play with the winners and who with the losers?

    Best regards

    Via

    0
    1. danielc0 Posted messages 2195 Registration date   Status Member Last intervention   285
       

      Hello,

      If it's volleyball, I don't think there can be a draw.

      0
    2. gigipong Posted messages 128 Registration date   Status Member Last intervention   1
       

      Hello,

      There is never a draw.

      0
      1. gigipong Posted messages 128 Registration date   Status Member Last intervention   1 > gigipong Posted messages 128 Registration date   Status Member Last intervention  
         

        the games are played to 5 points, the first to 3 points.

        0
      2. danielc0 Posted messages 2195 Registration date   Status Member Last intervention   285 > gigipong Posted messages 128 Registration date   Status Member Last intervention  
         

        Can you provide feedback on the formulas I proposed? And please specify your Excel version?

        Daniel

        0
      3. gigipong Posted messages 128 Registration date   Status Member Last intervention   1 > danielc0 Posted messages 2195 Registration date   Status Member Last intervention  
         

        I have Office 2021.

        Is it important for formulas?

        0
  6. via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     

    Re

    A solution with basic formulas valid on older versions of Excel :

    https://cijoint.org/r/aG5KbCrL#mwbWQQH4mzM3zOl464/6foak2eIwaloHP0+CU+MdwHk=

    Cdlmnt

    Via

    0
    1. gigipong Posted messages 128 Registration date   Status Member Last intervention   1
       

      Hello via55,

      My goal is for the desired result to be displayed directly in columns J and L without going through columns F and G.

      I don’t know if a single formula (which is what I’m looking for) can combine the two results (first the winners against each other, the losers as well, and the sort from smallest number to largest) and achieve my goal.

      Best regards.

      0
      1. danielc0 Posted messages 2195 Registration date   Status Member Last intervention   285 > gigipong Posted messages 128 Registration date   Status Member Last intervention  
         

        For the columns, you just hide them.

        Daniel

        0
  7. via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     
    Re,

    I don’t know of a method (outside of a macro) that simultaneously determines the winners and sorts them by number to be able to combine them in a single operation.

    As Danielc0, whom I salute by the way, said, you just need to hide columns F and G to have a clean table that roughly matches what you’re looking for, I think.

    However, I had forgotten that the winners had to replay against each other and the losers as well, and I wasn’t aware of your rule of the first to reach 3, so I redid my table in that sense:

    https://cijoint.org/r/oA4uWTLp#7IpBVnMNSUm+Kqq+J+IW1iNJ41CEJeKf9gC19c5192I=

    Cdlmnt

    Via

    0
    1. gigipong Posted messages 128 Registration date   Status Member Last intervention   1
       

      Good evening,

      Thank you all for your promptness; it's really great to have concrete ways of doing things.

      And I will be able to use all of that.

      Kind regards.

      0