Class name draw

Materials/tools: Excel20 10

1, after turning on the computer, directly enter the excel software, create a blank form document, and enter what we want to extract in a column of cells in the form, such as name and number.

2. After the input is completed, we re-select a cell in the current form document as the display of the final extraction result.

3. Then, we enter the following formula in the lucky draw result cell: "=INDEX(A:A, rand between (2,61+0)".

4. In the formula "=INDEX(A:A, rand between (2,61+0)", A:A means that the range of cell columns we want to extract is column A, which can be customized.

5. After the formula is entered, an extraction result will be randomly generated in the extraction result cell. We can set the format for the extraction result cell: font, font size, color, etc.

6. After setting, if we want to start the lottery or draw lots, we only need to select the cell of the drawing result, and then press and hold the "F9" key on the keyboard. After pressing, the extraction result will be randomly generated in the extraction content we selected in the extraction result cell, and we can generate an extraction result by releasing "F9".