ow to generate random value from a given list in Excel?
To generate random number is easily done by the function =RANDBETWEEN(range), but have you ever tried to generate random value from a given list as below screenshot shown?
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
Actually, there are some easy formulas that can help you to quickly generate random value from a given list.
Select a blank cell that will place the random value, type this formula =INDEX($A$2:$A$16, RANDBETWEEN(2, 16)), then press Enter key. See screenshot:
In the formula, A2:A16 is the given list you want to use, 2 and 16 are the starting row number and ending row number of the list.
If you want to generate several random values from the list, you can drag the formula down as you need. See screenshot:
You can press F9 key to refresh the values.
Note: If you want to generate random number based on a list, you can use this formula =INDEX($I$2:$I$7, RANDBETWEEN(1, 6)), and press Enter key.
- How to generate random number without duplicates in Excel?
- How to keep/stop random numbers from changing in Excel?
- How to generate random Yes or No in Excel?
- How to generate random value based on assigned probability in Excel?
|Here the Insert Random Data of Kutools for Excel can help you quickly insert random unique integer, date, or random time, text string, custom list as you need.|