Md. Araf Bin Jayed
To select a winner from a lottery, we need to do a raffle draw. Drawing raffles manually is time-consuming and tedious if there are many participants. But this process becomes easier if we do an electronic raffle draw. If we take the help of Microsoft Excel in this regard, this process becomes simpler and more effortless. In this article, we will show you how to make an electronic raffle draw in Excel.
Download Practice Workbook
You can download the free Excel workbook here and practice on your own.
2 Easy Ways to Make Electronic Raffle Draw in Excel
In our article, you will see two different methods to make an electronic raffle draw in Excel. We will nest the RANDBETWEEN function with the INDEX function in our first method. As for our second approach, we will combine the INDEX function with the MATCH function to make an electronic raffle draw. For our two procedures, we will use the following data set.
1. Nesting RANDBETWEEN Function with INDEX Function to Make an Electronic Raffle Draw
In our first approach, we will nest the RANDBETWEEN function with the INDEX function for our working purpose. First, the RANDBETWEEN function will generate a random number from the data set. Then the INDEX function will show the value that is fixed for that random number. For a better understanding, follow the following steps.
Step 1:
- Firstly, we will use the following data set for our procedure.
Step 2:
- Secondly, insert the following nested formula in cell C16 to see the winner.
=INDEX(C5:C14,RANDBETWEEN(1,10))
Formula Breakdown
- RANDBETWEEN(1,10): Firstly, The RANDBETWEEN function will generate a random number from 1 to 10. As we have 10 entries in our data set, it will take 1 as the lower limit and 10 as the upper limit.
- INDEX(C5:C14,RANDBETWEEN(1,10)): Then, the INDEX function will show the name that is fixed for the randomly selected number.
Step 3:
- Thirdly, press Enter and you will see a winner’s name randomly selected by applying the above functions.
Step 4:
- Furthermore, by pressing F9 on the keyboard, you can automatically generate more names.
Read More: How to Randomly Select a Winner in Excel (2 Easy Ways)
Similar Readings
- Excel VBA: Random Selection from List (3 Examples)
- How to Generate a Random String from a List in Excel (5 Suitable Ways)
- Randomly Select from a List in Excel (5 Swift Methods)
- How to Randomly Select Participants in Excel (4 Easy Ways)
- How to Select Names Randomly in Excel (5 Useful Methods)
2. Combining INDEX and MATCH Functions to Make an Electronic Raffle Draw in Excel
In our second method, we will combine the INDEX function and the MATCH function to make electronic raffle draw. This method will also include the use of the MAX function and the MIN function of Excel. This method is applicable if you have a set of values assigned to each raffle holder and want to decide the winner based on those values.
2.1 Draw the Maximum Value from Raffle
In this section, we will take the maximum value from the data set to choose the winner. For that purpose, we will insert the MAX function in the combination formula of the INDEX function and the MATCH function. To do that, go through the following steps.
Step 1:
- Firstly, take the data set and make an extra table to announce the winner.
Step 2:
- Secondly, write the following formula in cell C16 to determine the winner.
=INDEX(C5:C14,MATCH(MAX(D5:D14),D5:D14,0))
Formula Breakdown
- MAX(D5:D14): The MAX function will find the maximum value from the cell range D5:D14.
- MATCH(MAX(D5:D14),D5:D14,0): Then the MATCH function will search for the location of that maximum value and it will find an exact match.
- INDEX(C5:C14,MATCH(MAX(D5:D14),D5:D14,0)): The INDEX function will get the location range from the MATCH function and the INDEX function will return the name as the result who holds the maximum value.
Step 3:
- Thirdly, hit the Enter button to get the desired result which is Draco.
- Consequently, the result will be based upon the lottery number with the highest value in it.
2.2 Draw the Minimum Value from Raffle
If you want to decide the winner based on the minimum value from the list, then this procedure will help you to do that. We will apply the MIN function in the combined formula to see the result. The detailed steps for this procedure are below.
Step 1:
- In the beginning, type the following formula to see the winner in cell C16.
=INDEX(C5:C14,MATCH(MIN(D5:D14),D5:D14,0))
Formula Breakdown
- MIN(D5:D14): The MIN function will search for the minimum value in the cell range D5:D14.
- MATCH(MIN(D5:D14),D5:D14,0): Then, the MIN function will find the location of that minimum value and it will find an exact match.
- INDEX(C5:C14,MATCH(MIN(D5:D14),D5:D14,0)): The INDEX function will get the location range from the MATCH function and the INDEX function will return the name as the result who holds the minimum value.
Step 2:
- Secondly, the name of the winner will appear after pressing the Enter button.
- In our example, the winner is Ginny who holds the lowest value of the lottery number.
Read More: Random Selection Based on Criteria in Excel (3 Cases)
Conclusion
That’s the end of this article. We hope you find this article helpful. After reading the above description, you will be able to make an electronic raffle draw in Excel automatically by using any of the above-described methods. Please share any further queries or recommendations with us in the comments section below. The Exceldemy team is always concerned about your preferences.
Related Articles
- How to Randomly Select Rows in Excel (2 Ways)
- How to Make a Random Selection from List Without Repetition in Excel
- Random Selection from List with No Duplicates in Excel (5 Cases)
- How to Select a Random Sample from a Population in Excel (3 Ways)
- Generate Random Date and Time in Excel (3 Ways)
- How to Select Random Sample in Excel (4 Methods)
