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()
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.
Follow below given steps:-
This is the way we can return the randomize list in Microsoft Excel.
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.