1. First, open a blank Excel table, enter the prize names in column A in turn, and then create a new lottery table elsewhere in the table.
2. Then enter the function "RANDBETWEEN" in the lottery form.
3. Then enter the serial number of the prize after the function parentheses, where the serial number of the prize in column A is 2-7.
4. Insert the index function before the function "RANDBETWEEN"
5. Finally, enter the column where the prize is located in front of the function RANDBETWEEN, here is column A, the operation is "A:A", and then press enter directly.
6、? Now you can start the lottery. Press F9 directly here for the lucky draw.