» Randomly Selecting a Value from a Range
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem: 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:
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- A Mathematician Plays the Stock Market
- Absolute Beginner's Guide to Microsoft Excel 2002
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
No comments have been submitted.
