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.

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 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 ...

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 remains a powerful tool for data analysis and manipulation, and staying up-to-date with the latest formulas is crucial for maximizing your productivity and improving your spreadsheets.

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 ...