Following my Excel lottery number generator video I have had frequent requests for a Lotto 6/55 version. So here it is.
This spreadsheet demonstrates some fantastic Excel techniques, and as always the file is unprotected so that it can all be investigated.
The following Excel features are used:
- The RAND function is used to generate the random numbers
- The RANK and COUNTIF functions are used to rank the random numbers from 1 to 55 for retrieval of the balls
- The VLOOKUP function is used to retrieve the ball numbers
- Some VBA is used to perform the formula calculations when a button is clicked (Manual calculation has been chosen over automatic for the workbook)