random numbers, how can you utilize it without repeating them

[RS]

How can you use random numbers without repeating them on a worksheet? The way
it is set up now is, example: =RANDBETWEEN(1,8)
I would like to be able to use the random between but I don't want the
numbers to repeat themselves within the worksheet. Any suggestions or Ideas?

[Peo Sjoblom]

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

--
Regards,

Peo Sjoblom

(No private emails please)


"RS" <[email protected]> wrote in message
news:[email protected]...
> How can you use random numbers without repeating them on a worksheet? The
> way
> it is set up now is, example: =RANDBETWEEN(1,8)
> I would like to be able to use the random between but I don't want the
> numbers to repeat themselves within the worksheet. Any suggestions or
> Ideas?