Randomize List in Microsoft Excel

In this article, we will learn how we can make list randomizer in Microsoft Excel.

We will use the Rand function to generate the Random list. Before creating the random number’s list, we will understand about Rand function.

Rand: - Returns a random number greater than or equal to 0 and less than 1, evenly distributed (changes on recalculation).

Syntax of “RAND” function:          =RAND()

For example:-

  • Select the cell A1 and write the formula.
  • =RAND(), and press Enter.
  • The function can return any random number

image 1


Note:- Random numbers change every time a cell on the sheet is calculated.

Let’s take an example to understand.

We have a list in Column A. Now, we need to create random word list generator.

image 2


Follow below given steps:-

  • Write the formula in cell B1.
  • =RAND(), and press Enter.
  • Copy the same formula in range B1:B6.

image 3


image 4


This is the way we can return the randomize list in Microsoft Excel.

xlsx-1567 Download-Randomize List-xlsx


Leave a Reply

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

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube