![]() ![]() 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. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |