Generate Random Name No Repeat

[delta]

sheet1 in A2:A1200 contain student name when click on button generate random name in Cell D1 but do no repeat name. how it is work

 

[AlanSidman]

In B2 type =rand() and copy down
In C2 type =RANK(B2,$B$2:$B$1201,1)+COUNTIF($B$2:$B$2,B2)-1 and copy down
In D2 type =INDEX(A2:A1201,MATCH(1,C2:C1201,0))

 

[bosco_yip]

1] In D1, enter :

=INDEX(A2:A1200,RANDBETWEEN(2,1200))

2] Press F9 to renew student name.

Regards
Bosco

 

[Peter Bartholomew]

The attached workbook generates random numbers in descending order. Clearly a simple lookup could turn this into a list of student names sorted in alphabetical order.

If the sheet takes a little longer to calculate than you might expect, bear in mind that it has generated 50 such random sequences, assigned the values to bins and plotted the distribution of values across the bins for each draw.

Must have had too much time on my hands at some point!

 

[Peter Bartholomew]

If order is significant, you might prefer this though ...