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 <5123C476180B0@OfficeKB.com>,
"nonoi via OfficeKB.com" <forum@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?