One play to try ..

List the numbers: 1 - 30 into A1:A30
Put in B1: =RAND()
Copy B1 down to B30

Put in C1: =INDEX(A:A,RANK(B1,$B$1:$B$30))
Copy C1 down to C30

C1:C30 will return a random shuffle
of the numbers: 1-30 (non-repeating)

Press F9 to regenerate

We could simply replace A1:A30
with whatever 30 unique numbers (other than 1-30)
or items that is to randomly shuffled
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Kleverton Silva" <Kleverton wrote in
message ...
how do i do to make Excel to generate random numbers to 30 persons?, but
one
detail, no repeated numbers! i tried the "=Randbetween(1;30)" but i
couldn't
avoid repeated numbers...