3. Label the range B1:B10 with "number of winners."
4. Type in each prize number in the range B1:B10 and change column H from "0" to "1" after you enter each prize number. Repeat steps 2-4 until you have entered all of your prizes into column H of your table Learn Excel with Skill India Certificate
Create the lucky draw program in Excel:
ReplyDelete1. Create the range A1:A10 and label it "prizes."
2. Type in each prize in the range A1:A10.
3. Label the range B1:B10 with "number of winners."
4. Type in each prize number in the range B1:B10 and change column H from "0" to "1" after you enter each prize number. Repeat steps 2-4 until you have entered all of your prizes into column H of your table
Learn Excel with Skill India Certificate