View original (French)

Random selection without duplicates

Solved
missfraise02 -  
 sc -
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 Posted messages 8400 Registration date   Status Member Last intervention   1 784
     
    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 Posted messages 8400 Registration date   Status Member Last intervention   1 784
       
      You're welcome, I look forward to reading you again on the Forum

      Best regards
      Patrice
      0