To pull a random value out of a list or table, we’ll need a random row number.
For the columns argument, we simply use 1, since we want a name from the first column.
Note that RANDBETWEEN will recalculate whenever a worksheet is changed or opened.
you could use INDEX to retrieve individual values, or entire rows and columns.
RANDBETWEEN recalculates each time a worksheet is opened or changed.
ROWS Function
The Excel ROWS function returns the count of rows in a given reference.
Related videos
How to pick names out of a hat with Excel
