RANDARRAY

Dynamic arraysMicrosoft 365volatile

A spilled array of random numbers.

Syntax

RANDARRAY([rows], [columns], [min], [max], [whole_number])

Examples

=RANDARRAY(10, 1, 1, 100, TRUE)

→ 10 random integers 1–100

Related functions

RAND RANDBETWEEN SEQUENCE

More Dynamic arrays functions

BYCOL BYROW CHOOSECOLS CHOOSEROWS DROP EXPAND FILTER GROUPBY HSTACK MAKEARRAY MAP PIVOTBY

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.