Formula
 

How do I stop getting duplicate numbers when using the formula -
=randbetween(1,24)

Formula
 

=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