Posted inResources Excel Tips: Selecting a random value from a List. Table of Contents Toggle Excel Tips: Selecting a random value from a List.Related 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 Related posts: 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 Free Webmaster tools Post navigation Next PostExcel tips: Finding the Last Day of a Given Month
