random numbers, how can you utilize it without repeating them
 

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?

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

--
Regards,

Peo Sjoblom

(No private emails please)


"RS" wrote in message
...
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?