Okebiz Video Search



Title:Create Random Text with CHOOSE in Excel
Duration:04:44
Viewed:21,736
Published:13-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 1


DOWNLOAD MP4

Download Server 2


DOWNLOAD MP4

Alternative Download :



SPONSORED
Loading...
RELATED VIDEOS
Top 25 Excel 2016 Tips and Tricks Top 25 Excel 2016 Tips and Tricks
27:44 | 552,123
4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1 4 SMART Ways to use Custom Formatting instead o...
16:12 | 655,797
How to use a SKU system in your small business - The Handmade Mastermind How to use a SKU system in your small business ...
31:15 | 53,334
Excel IF Function with PARTIAL Text Match (IF with Wildcards) Excel IF Function with PARTIAL Text Match (IF w...
06:37 | 374,267
Vlookup Function in Excel for Beginners Vlookup Function in Excel for Beginners
11:35 | 206,302
How to Generate a Random List of Names Based On Set List of Names in Google Sheets/Excel How to Generate a Random List of Names Based On...
11:39 | 35
VLOOKUP Tutorial for Excel - Everything You Need To Know VLOOKUP Tutorial for Excel - Everything You Nee...
21:50 | 187,429
Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP) Discover What XLOOKUP Can Do For YOU (R.I.P. Ex...
06:59 | 931,910


coinpayu