The Excel RANDARRAY function generates an array of random numbers that can be whole or decimal. The new dynamic array RANDARRAY function is very easy to apply—you select the number of rows and columns, and then you choose the smallest and largest random number to produce. The last parameter determines whether there should be decimal or whole numbers. When RANDARRAY returns multiple results, they are spilled into adjacent cells.

This open-access Excel template is a useful tool for financial analysts, business analysts, consultants, corporate executives, and anyone preparing a corporate presentation.

Discover the power of Excel and boost your skills with our comprehensive Introduction to Excel course.

You can also explore other related functions such as—XMATCH, SEQUENCE, RANK, and SORTBY.