Excel Tips: Selecting a random value from a List.

Excel Tips: Selecting a random value from a List.

Using the RAND function in the following formula:

=INDEX(A2:A7,ROUND(RAND()*COUNTA(A2:A7),0))

The value returned by the formula will change with each recalculation (F9).

Related posts:

Excel tips: How to Locate Merged Cells in Microsoft Excel (and then get rid of it)

Excel tips: Finding the Last Day of a Given Month

Excel Tips: Entering dates quickly, without having to use delimiters to separate month, day, and year.

Excel Tips: Calculating a Date Based on Year, Week Number and Day of the Week