» Random Selection from a List

CATEGORY - Excel Formula and Function VERSION - All Microsoft Excel Versions

Problem:

Randomly selecting one of the values from the list in column A.

Solution:

Use the INDEX, ROUND, RAND, and COUNTA functions in the following formula:
=INDEX(A2:A7,ROUND(RAND()*COUNTA(A2:A7),0))

Note:
The value returned by the formula will change with each recalculation ( key).
Screenshot // Random Selection from a List