» Random Selection from a List
Randomly selecting one of the values from the list in column A.
Use the INDEX, ROUND, RAND, and COUNTA functions in the following formula:
The value returned by the formula will change with each recalculation ( key).
|Screenshot // Random Selection from a List|