Why do I get duplicate numbers when I use the formula for random numbering.
A Anne Troy Jul 20, 2005 #2 Because random includes duplicates. If there weren't duplicates, they wouldn't be "random". Try this: http://www.ozgrid.com/VBA/RandomNumbers.htm ******************* ~Anne Troy www.OfficeArticles.com Gloria said: Why do I get duplicate numbers when I use the formula for random Click to expand... numbering.
Because random includes duplicates. If there weren't duplicates, they wouldn't be "random". Try this: http://www.ozgrid.com/VBA/RandomNumbers.htm ******************* ~Anne Troy www.OfficeArticles.com Gloria said: Why do I get duplicate numbers when I use the formula for random Click to expand... numbering.
