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 réponses

Réponse 1 / 2
Patrice33740 Posted messages 8400 Registration date   Status Membre Last intervention   1 781
 
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
missfraise02
 
So in every case, all the numbers were used, great!
Thank you very much!
0
Patrice33740 Posted messages 8400 Registration date   Status Membre Last intervention   1 781
 
You're welcome, I look forward to reading you again on the Forum

Best regards
Patrice
0