RSS Feed   Twitter

Selecting a random value from a List.

Posted by Mahmud Hasan on May 27th, 2008

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).

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

Posted in Tips and Tricks
«
»
You can leave a response, or trackback from your own site.

Leave a Reply

Twitter Delicious Facebook Digg Stumbleupon Favorites More
Powered by WordPress | BestInCellPhones.com Offers BlackBerry Phones for Sale. | Thanks to Wordpress Themes, MMORPGs and Conveyancing