Okebiz Video Search



Title:Create Random Text with CHOOSE in Excel
Duration:284
Viewed:18,829
Published:12-08-2014
Source:Youtube

http://www.contextures.com/excelfiles... Visit this page to download the sample file.

To enter random numbers on an Excel worksheet, you can use the RANDBETWEEN function. Set a bottom and top number, and a random number from that range is returned.

The RANDBETWEEN function can only return numbers, but you can use it with the CHOOSE function, to return random text.

In this example, CHOOSE and RANDBETWEEN work together in a formula, to return a random region name (East, West or Central) in one column, and a random gender (Male or Female), in another column.

Watch this video to see the steps for using RANDBETWEEN on its own, and combined with CHOOSE.

For more examples of the CHOOSE function, visit this page on my Contextures blog:

http://blog.contextures.com/archives/...

0:00 Introduction
0:18 Score column needs random numbers
0:23 Start the RANDBETWEEN formula
0:50 Copy RANDBETWEEN formula down
0:59 Region and Gender columns need random text
1:09 Use RANDBETWEEN with CHOOSE
1:34 Add RANDBETWEEN formula for Index number
1:57 Add text items as values for CHOOSE function
2:27 Complete the formula, and copy it down
2:44 Start the Region formula
3:01 Add RANDBETWEEN formula for Index number
3:17 Add cell references as values for CHOOSE function
3:48 Complete the formula, and copy it down
4:02 Paste the random formulas as values
4:32 Download the sample file

SHARE TO YOUR FRIENDS


Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
How to generate a Random List in Excel How to generate a Random List in Excel
04:22 - 334
☑️ 19 Things You Need To Know About VLOOKUP In Excel ☑️ 19 Things You Need To Know About VLOOKUP...
22:51 - 28
Excel Magic Trick 302: Randomly Select Names No Repeats Excel Magic Trick 302: Randomly Select Names No...
03:31 - 141
Excel Array Formulas Explained with MIN and IF Functions (Part 1 of 5) Excel Array Formulas Explained with MIN and IF ...
12:48 - 72
How to Make a Password with Random Letters and Numbers in Excel - Tutorial How to Make a Password with Random Letters and ...
04:15 - 111
Use RANDBETWEEN and DATE to Generate Random Dates In Excel Use RANDBETWEEN and DATE to Generate Random Dat...
03:49 - 187
INDEX MATCH Explained (An Alternative to VLOOKUP) INDEX MATCH Explained (An Alternative to VLOOKUP)
19:28 - 264
Create A Timestamp In Excel With A Formula Create A Timestamp In Excel With A Formula
07:32 - 64