However, Excel's random number functions are volatile, meaning they change constantly. In this article, I'll show you how to generate and fix random numbers and remove duplicates.

Internally, Excel is calculating 4,000,000 random numbers! You probably don’t need that large of a pool. Instead, multiply the rows argument by another value, such as 10.

B.D. McCullough, a professor at the LeBow College of Business at Drexel University, examined Microsoft’s revamped number generator implemented in Excel 2007 and found it lacking as well.