In this article, I'll show you how to generate and fix random numbers and remove duplicates. Excel has three functions ... RANDARRAY formula, you will see a #SPILL! error, and the array of random ...