» Randomly Selecting a Value from a Range
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Randomly selecting one of the letters from the range A1:C4.
Solution:
Use the INDEX and RANDBETWEEN functions in the following formula:
=INDEX(A1:C4,RANDBETWEEN(1,4),RANDBETWEEN(1,3))
Book Store:
Recommended Books:
- Windows XP for Dummies
- The Basics of Finance: Financial Tools for Non Financial Managers
- Yes, You Can Time the Market!
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Retire Young, Retire Rich
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
No comments have been submitted.


