=randbetween() doesn't have a memory.
If you're populating a range with random numbers, you may want to use J.E.
McGimpsey's RandInt Userdefined function:
http://www.mcgimpsey.com/excel/udfs/randint.html
Rod wrote:
How do I stop getting duplicate numbers when using the formula -
=randbetween(1,24)
--
Dave Peterson