View original (French)

Random selection without duplicates

Solved
missfraise02 -  
Hello,

I'm looking for a formula for a belote tournament that assigns a random number to each player. The numbers range from 1 to 100.

With the formulas I found, some numbers were repeated twice, and therefore some were missing...

Thank you!

<config>Windows Vista Firefox 9.0.1</config>

2 answers

  1.  Patrice33740
    Hello,

    With Excel (or Calc):
    In A1:
    =RAND()
    In B1:
    =RANK(A1,A:A,1)

    and drag A1:B1 down to A100:B100

    --
    Best regards
    Patrice
    74
    1. missfraise02
      So in every case, all the numbers were used, great!
      Thank you very much!
      0
    2. Patrice33740
      You're welcome, I look forward to reading you again on the Forum

      Best regards
      Patrice
      0
    3. SO
      Does it work on Excel 2003?
      0
    4. Patrice33740
      yes
      0
    5. thealis
      Magnificent dear Patrice!!! I just kept going around in circles on the forums only to find dead ends. Finally, thank you!!!
      0