In this article, I'll show you how to generate and fix random numbers and remove duplicates. Excel has three functions ... and click "Values" (the icon containing the numbers one to three).