Tom’s Tutorials For Excel: Using the RAND Function to Extract Random Data
Here are examples of how numbers or data can be extracted using the
The examples and formulas listed below relate to the following picture.
Example 1: Randomly return a number between numbers, such as from 1 to 10.
Formula in cell A4 is
Example 2: Example 1 in practice, to randomly return an item in a 10-item list.
Formula in cell E7 is
Example 3: Similar to Example 1, this time from 65 to 90.
Formula in cell A20 is
Example 4: Example 3 in practice, to randomly return a letter of the alphabet.
Formula in cell A23 is