How do I use RANDARRAY in Excel?
Use RANDARRAY when you want to reshape arrays dynamically. Enter Rows, Columns, Minimum in that order, then add optional arguments when needed.
Excel Function
RANDARRAY
Generates an array of random numbers with specified rows and columns.
RANDARRAY([rows], [columns], [min], [max], [whole_number])Arguments
rows
OptionalEnter a numeric value.
columns
OptionalEnter a numeric value.
min
OptionalSpecify the minimum value for generated random numbers.
max
OptionalSpecify the maximum value for generated random numbers.
whole_number
OptionalTRUE returns whole numbers; FALSE or omitted returns decimals.
Practice Preview
Use RANDARRAY to return the result with these settings (Rows: 5, Columns: 2, Minimum: 1, max: 100, Whole number: TRUE).
Example Table
| # | AProduct ID | BCategory | CProduct Name | DSales |
|---|---|---|---|---|
| 2 | P001 | Food | Apple | 1200 |
| 3 | P002 | Food | Banana | 980 |
| 4 | P003 | Stationery | Notebook | 450 |
| 5 | P004 | Stationery | Pen | 300 |
| 6 | P005 | Food | Grapes | 1500 |
| 7 | P006 | Stationery | Ruler | 250 |
| 8 |
How to Use (Formula)
=RANDARRAY(5, 2, 1, 100, TRUE)Result
50, 50 | 50, 50 | 50, 50 | 50, 50 | 50, 50
Practice This Function
RANDARRAY FAQ
Where can I practice RANDARRAY?
Use the "Start Function Practice" button to jump straight into RANDARRAY drills.
What arguments does RANDARRAY use?
The main arguments are Rows, Columns, Minimum, max, Whole number. Start with the required ones, then add optional arguments if needed.