The RAND function gets the random value from 0 to 1. Creating a named range Value for column “Value” Creating a named range Name for column “Name”įigure 4. Write the name for the cell range and press enterįigure 3.Select the cell range that should be named.To create a named range we should follow the steps: In order to make the formula more clear, we will create a named range Name for cell range B3:B7 and a named range Value for the cell range C3:C7. We want to get the random name from column B and to place the result in the cell E3. Data for the electronic raffle Set Up an Electronic Raffle with Excel Functions The second table has an empty cell E3 where we will get the winner name of the electronic raffle.įigure 2. In column “Value” will be placed random numbers from 0 to 1 that will help us in the calculation. Our table consists of 2 columns: “Name” (column B) and “Value” (column C). Setting up Our Data for the Electronic Raffle number1, – the numbers from which we want to get the maximum values.The generic formula for the MAX function is: lookup_array – the array where we want to find a value.lookup_value – a value which we want to find in the lookup_array.The parameters of the MATCH function are: The generic formula for the MATCH function is: column_num – a column in the array which returns a value.row_num – a number of a row in the array for which we want to get a value.array – a range of cells where we want to get a data.The parameters of the INDEX function are: The generic formula for the INDEX function is: The function returns a random decimal number between 0 and 1 and has no parameters. The generic formula for the RAND function is: The final result of the formula Syntax of the RAND Formula This step by step tutorial will assist all levels of Excel users to get the random winner in the electronic raffle.įigure 1.
#FREE RAFFLE SOFTWARE IMPORT FROM EXCEL HOW TO#
How to Use Excel to Set Up an Electronic RaffleĮxcel allows us to set up an electronic raffle using the RAND, INDEX, MATCH and MAX functions.
0 kommentar(er)
