flyingtore.blogg.se - Random list generator names

#Random list generator names how to#

Using the formula to get a random name from the range Insert the formula: =CHOOSE(RANDBETWEEN(1,5),"George","Matt","Ann","Sam","Jennifer")įigure 2.To apply the formula, we need to follow these steps: The values of the function are “George”, “Matt”, “Ann”, “Sam”, “Jennifer”.

The result of this function is a random number between 1 and 5 which is the index_num parameter of the CHOOSE function. The parameter bottom of the RANDBETWEEN function is 1 and the top is 5. In the cell B3, we want to get a random name from the name list: “Mike”, “John”, “Lilly”, “Robert” and “Jennifer”.

value1,, ,… – a list of values from which one value is returned.

index_num – an index of the value which we want to retrieve.

The parameters of the CHOOSE function are: The generic formula for the CHOOSE function is:

top – a value to which we want to get a random value.

bottom – a value from which we want to get a random value.

The parameters of the RANDBETWEEN function are: The generic formula for the RANDBETWEEN function is: The final result of the formula Syntax of the RANDBETWEEN Formula

#Random list generator names how to#

This step by step tutorial will assist all levels of Excel users to learn how to randomly generate words in Excel.įigure 1. Find Out How to Generate Random Names in ExcelĮxcel allows us to get a random number from a range using the CHOOSE and RANDBETWEEN functions.