» 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.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
