Home / Discussions

Report Offensive Message

RAND function can generate duplicates
Because the RAND function will randomly assign numbers to each cell, there is potential there for duplicates.

I found a website that gives an example of a customized function that will generate unique random numbers:

http://www.ozgrid.com/VBA/RandomNumbers.htm

Vicky
Posted by VickyToo
7th Dec 2007