» 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:
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Special Edition Using Microsoft Word 2002
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Adventure Capitalist: The Ultimate Road Trip
No comments have been submitted.
