» Random Selection from a List
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
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 (
Book Store:
Recommended Books:
- Learn MS Excel 2002 VBA/XML Programming
- Microsoft Excel VBA Programming for the Absolute Beginner
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Finance and Accounting for Nonfinancial Managers
- Adventure Capitalist: The Ultimate Road Trip
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
