View original (French)

Excel file bug

Solved
DodoMichel -  

Hello,

I still have the same problem in my file if I have more than 28 teams in the List tab in BJ14.

I didn't notice it before because I used it only up to 28 teams.

Could you please, please, look at my bug?

Thanks for your feedback

Below is the link

Regards

Dodo

https://cijoint.org/r/pZRNSMJB#c23z3ShCSINV9ifsHrie00dtDuysbA+E7tqo30hf2PI=

11 answers

  1.  Le Pingou

    Hello,

    It is necessary to extend the formulas in the columns (AF:BL) down to row 38 which will allow you to manage 64 trinities.

    Regards,
    Le Pingou

    1
    1. DodoMichel Author

      Hello,

      In simulation, everything works; to be seen in real life, but there is no reason!

      Thank you very much for your help.

      Best regards

      Dodo

      1
      1. JCB40

        Hello

        Your file is password-protected

        Best regards

        0
        1. DodoMichel Author

          Hello,

          Sorry, I thought the old discussion was with !

          marcel1924

          Thank you.

          Best regards

          Goodbye

          0
          2. danielc0

            Hello,

            What do the numbers in columns AK:AL correspond to? What is your version of Excel?

            Daniel

            0
            1. DodoMichel Author

              Hello,

              I don’t know how to answer for the numbers in columns AK and AL.

              Is it to rank winners against winners?

              I’m using Excel 2016

              Thank you

              Best regards

              Dodo

              0
              1. danielc0

                What needs to be done to reproduce the error?

                Daniel

                0
                1. Le Pingou
                  Hello, Just by the way, add one line to your 1-line table in Part 5 See below:

                  Best regards.
                  Le Pingou

                  0
                  2. DodoMichel Author

                    Hello,

                    32 teams is fine.

                    However, if I add more, I have the same problem.

                    Is it possible to fix it?

                    Thank you

                    Best regards

                    Dodo

                    0
                    1. Le Pingou

                      Hello,

                      Put the file with the additions at disposal and I will look where the problem is.

                      Regards.
                      Le Pingou

                      0