Explanation
The ExcelRANDBETWEEN functionreturns a random integer between given numbers.
The result is random numbers between 1-100.
RANDBETWEEN is avolatile functionthat recalculates when a worksheet is opened or changed.
This includes any edits to the worksheet, or simply opening the workbook.
RANDBETWEEN recalculates each time a worksheet is opened or changed.
RANDARRAY Function
The Excel RANDARRAY function generates an array of random numbers between two values.
The size or the array is specified byrowsandcolumnsarguments.
The generated values can be either decimals or whole numbers.
Related videos
How to pick names out of a hat with Excel
