Generate an array of random numbers.

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

- Rows - [OPTIONAL] the row count
- Columns - [OPTIONAL] the column count
- Min - [OPTIONAL] the minimum value
- Max - [OPTIONAL] the maximum value
- Integer - [OPTIONAL] Boolean, TRUE or FALSE

`=RANDARRAY(10,1)`

This example uses the RANDARRAY function to generate a single random number between 0 and 1. The function will return a single random number in the specified range each time it is used.

`=RANDARRAY(1,10)`

This example uses the RANDARRAY function to generate a single random number between 1 and 10. The function will return a single random number in the specified range each time it is used.

`=RANDARRAY(3,1,1,5)`

This example uses the RANDARRAY function to generate three random decimal values in columns between 1 and 5. The function will return three random decimal values in the specified range each time it is used.

The RANDARRAY function is used to generate a random array of numbers with a specified size. The values generated are either decimals or whole numbers and are determined by the min and max arguments supplied. The function is volatile, so it may cause performance issues in large or complex worksheets.

- The RANDARRAY function generates a random array of numbers, specified by the number of rows and columns.
- By default, RANDARRAY returns an array of random numbers between 0 and 1.
- When the integer argument is set to true, RANDARRAY returns whole numbers instead.

The RANDARRAY function is a volatile function in Sourcetable that creates an array of random numbers. The size of the array is determined by the rows and columns arguments, and the generated values can be decimals or whole numbers.

The arguments for the RANDARRAY function are rows, columns, min, max, and an integer.

Yes, the RANDARRAY function may cause performance issues in large or complex worksheets.

- Be mindful of the size of the array you are generating.
- If you are generating large or complex arrays, try to limit the size to improve performance.
- Be aware that the RANDARRAY function is a volatile function, so it will recalculate every time the worksheet is recalculated.

Drop CSV