Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel. The recent article How to generate random letters in Excel shows you how to generate random letters.

Random number generation is an essential feature in Excel, allowing users to perform tasks such as simulations, creating test datasets, or experimenting with spreadsheet models. Excel provides three ...

Microsoft Excel can do a lot of cool things. If you need it to generate random numbers, Susan Harkins can show you how. Over the last few months, I’ve written about several of Excel’s new dynamic ...

Learn the best Excel formulas to enhance your skills in 2025! This tutorial covers underrated Excel functions including RANDARRAY for generating practice data, TRANSPOSE for dynamically restructuring ...

Microsoft is making some improvements to how formulas work in Excel, with a new feature called Dynamic Arrays that allows formulas to output values to more than one cell at a time. Microsoft has ...