Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to use Excel ROW Function
  • How to get first column number in range in Excel
  • How to get address of first cell in range in Excel
  • Convert text string to valid reference in Excel using Indirect function
  • How to retrieve first match between two ranges in Excel

Data Analysis Examples

  • How to Create Gantt Chart in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • How To Create Frequency Distribution in Excel
  • How To Remove Duplicates In Excel Column Or Row?
  • How to conditionally sum numeric data in an Excel table using SUMIFS

Data Validation Examples

  • Excel Data validation number multiple 100
  • Excel Data validation must not contain
  • Excel Data validation only dates between
  • Excel Data validation require unique number
  • Excel Data validation exists in list

How to fill cell ranges with random text values in Excel

by

To quickly fill a range of cells with random text values, you can use a formula based on the CHOOSE and RANDBETWEEN functions.

Formula

=CHOOSE(RANDBETWEEN(1,3),"Value1","Value2","Value3")

Note that RANDBETWEEN will calculate a new value whenever the worksheet is changed. Once you have values in the range, you may want to replace the formulas with values to prevent further changes.

Worked Example:   RAND vs RANDBETWEEN function examples in Excel

Explanation

In the example shown, the formula in C5 is:

=CHOOSE(RANDBETWEEN(1,4),"Red","Blue","Green","Pink")

Which returns a random color from the values provided.

How this formula works

The CHOOSE function provides the framework for this formula. Choose takes a single numeric value as its first argument (index_number), and uses this number to select and return one of the values provides as subsequent arguments, based on their numeric index.

Worked Example:   How to use Excel CHOOSE Function

In this case, we are using four values: Red, Blue, Green, and Pink, so we need to give CHOOSE a number between 1 and 4.

To generate this number, we use RANDBETWEEN, a function that returns a random integer between a bottom and top value. Since we are only working with 4 values in CHOOSE, we supply 1 for the bottom number and 4 for the top number.

Worked Example:   How to create Roll the Dice in Excel

When this formula is copied down, it will return one of the four colors.

Post navigation

Previous Post:

How to randomly assign data to groups in Excel

Next Post:

How to generate random number between two numbers in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to count specific words in a cell in Excel
  • Join cells with comma in Excel
  • How to translate letters to numbers in Excel
  • UPPER function: Description, Usage, Syntax, Examples and Explanation
  • How to count number of characters of text in a cell in Excel
  • Add months to date in Excel
  • Convert Unix time stamp to Excel date
  • Add years to date in Excel
  • How to calculate nth day of week in month in Excel
  • Sum race time splits in Excel
  • How to set check register balance in Excel
  • CUMIPMT function: Description, Usage, Syntax, Examples and Explanation
  • XIRR function: Description, Usage, Syntax, Examples and Explanation
  • SYD function: Description, Usage, Syntax, Examples and Explanation
  • DB function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles