For most purposes, RAND() provides a pretty good approximation of unique
random numbers for relatively small sets.

If you mean random integers, see

http://www.mcgimpsey.com/excel/randint.html





In article ,
"nonoi via OfficeKB.com" wrote:

i want to do the random number for every each cell without repeat the same
number?do you know how to solve my problem?