How to generate random text from the list?

by Best Excel Tutorial Data Analysis

In this Excel tutorial, you learn how to generate random text from a list.

Random text generator formula

Suppose that your list is in the A1: A10 cell range. You have some text there from which you want to generate one in some other cell.

Here is an Excel formula that solves your problem:

=INDEX(A1:A10,RAND()*ROWS(A1:A10)+1)

Generating Random text based on list

Drag it down to the number of cells you need it in.

Remember that every time the formula generates a new text, Each time you run the formula, it will generate a random item from a given list.

Related posts:

sample pivot dataHow to Show Year over Year Growth pivot table Create TableHow to Create Pivot Table from Multiple Sheets Default ThumbnailHow to Do an Exponential Regression in Excel to Predict Future Values
See also  How to Increment Row Number in Excel Formula