Generate Random Numbers in Excel 3 Simple Functions Watch this video on YouTube. Unlock more potential in Random number generation in Excel by reading previous articles we have written.

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

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.

The solution lies with using Excel's array feature to traverse a data list automatically and extract missing sequential numbers, even if the number list is out of order.

It's easy to return random values in Microsoft Excel, but returning random letters might leave you scratching your head. Fortunately, you only need two functions.

Learn to generate a Barcode in Microsoft Excel using a custom barcode font. You can also create a random barcode in Excel.