Microsoft Excel can do a lot of cool things. If you need it to generate random numbers, Susan Harkins can show you how.

It’s a ridiculously easy sequence to make, and yet it fooled programs designed to root out underlying order in seemingly random numbers. David Gawen Champernowne was born in 1912.

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.