Drawing Lots with Excel
An Excel file that teaches how to perform Conducting a Lottery Draw with Excel operation.
Excel Professional Drawing Lots with Excel
Participant names are recorded in the table. Ranking is done using random number generation. Duplicate entries are filtered out. The winner is marked on the table. The process is designed to be repeatable.
Hope it is useful.